Eric writes:

>    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);
> /*********/

Write a function in PL/pgSQL.

-- 
Peter Eisentraut   peter_e(at)gmx(dot)net   http://funkturm.homeip.net/~peter

In response to

• SQL( "if ...exists...),how to do it in the PostgreSQL? at 2001-05-31 05:42:41 from Eric

Responses

• Re: SQL( "if ...exists...),how to do it in the PostgreSQL? at 2001-06-06 15:58:49 from Tom Lane

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2001-06-06 14:52:58
	Subject: Re: vacuumdb -a -z hangs
Previous:	From: Peter Eisentraut	Date: 2001-06-06 14:45:46
	Subject: Re: psql bug or feature?