On 05/09/2011 10:38, Pau Marc Muñoz Torres wrote: > Hi follk > > i trying to performe a conditional insert into a table, indeed, what > i'm trying to do is not insert a record into the table if that record exist > > googleling i found something like > > insert into XX values (1,2,3) where not exist (select ....); > > but i'm having and error near where... > Shouldn't it be EXISTS, not EXIST? Anyway, what is the error you're getting? Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
