Pau Marc Muñoz Torres, 05.09.2011 11:38:
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...
anyone knows how do i can perfome this insert?

INSERT INTO xxx
SELECT 1,2,3
WHERE NOT EXISTS (SELECT ...)

Regards
Thomas


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to