Thanks to those who responded, I see PL/PgSQL is the way to go Regards, denis woodbury
on 10/11/08 1:32 PM, [NAME] at [ADDRESS] wrote: > Denis Woodbury <[EMAIL PROTECTED]> writes: >> I would like to know if this this type of statement can be used in >> Postgresql > >> IF NOT EXISTS (SELECT 1 FROM Table WHERE col1 = 'mystring' ) >> BEGIN >> ... >> END > > I suspect you are trying to type that directly into SQL. > You need to be using plpgsql in order to use procedural > logic (ie, if/then). > > regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
