--- On Tue, 12/11/07, Pau Marc Munoz Torres <[EMAIL PROTECTED]> wrote: > could i use a sentence similar to the mysql sentence > > insert if not exist into SP values > ('cesp','sp'); > > in postgresql?
Using standard ANSI-SQL the statement could be re-written: INSERT INTO SP SELECT a, b FROM VALUES ( 'cesp', 'sp' ) AS tmp( a, b ) LEFT JOIN Sp ON (Sp.col1,Sp.col2)=(tmp.a,tmp.b) WHERE (Sp.col1,Sp.col2) IS NULL; Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly