Greetings.
I am writting up a function in PL/pgSQL to automate a couple of multi-table
updates, and I have a question.
I need to check to see if the data is already in the database, and if it is,
perform and update, or if it's not, perform an insert. The lookup is
against a primary key, so I only have to worry about 1 or 0 rows being
returned from the select statement.
I attempted something like
IF SELECT id FROM overview WHERE id = 100 ...
but I get an 'error near SELECT' returned from the database.
Any help would be apprieciated.. :)
Sincerely, Warren