This blog post will demonstrate basic concepts of the ALTER TABLE command for changing an existing PostgreSQL table. INSERT statements will be introduced as well to populate an empty table with mock data. Visit Part 1 of this series for a refresher of the material covered up to this point.
Searching numerous columns of data for particular records is time-consuming and less than productive. In this post, I will demonstrate pattern matching examples using the powerful LIKE operator available in both traditional SQL and PostgreSQL. Along with briefly visiting the PostgreSQL keyword ILIKE as well. This post will be Part 1 in a planned 3 part series on pattern matching.
In today’s post, I will demonstrate examples of PostgreSQL’s IN operator in stand-alone scenarios, along with additional uses combining IN with the NOT operator for other solutions or ideas of value matching checks against a list of values.
In today’s example, I will add to a previous post by enhancing an existing PL/pgSQL function utilizing conditionals and defined validation checking.
