SQL( "if ...exists...),how to do it in the PostgreSQL?

From: "Eric" <e-lz(at)263(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: SQL( "if ...exists...),how to do it in the PostgreSQL?
Date: 2001-05-31 05:42:41
Message-ID: 3B15D9D1.21199@mta3
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I can realize this function in the SYBase,but How can i do it in the PostgreSQL?

/****SQL***/
if not exists(select id from test) insert into test(id) values (280);
/*********/

_____________________________________________
http://shopping.263.net/category21.htm
http://shopping.263.net/category23.htm

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2001-05-31 08:57:07 Re: First version of multi-key index support for GiST
Previous Message Tom Lane 2001-05-31 05:09:05 Re: Imperfect solutions