Home > mailing lists

SQL( "if ...exists...),how to do it in the PostgreSQL? - Mailing list pgsql-hackers

From	Eric
Subject	SQL( "if ...exists...),how to do it in the PostgreSQL?
Date	June 5, 2001 20:15:45
Msg-id	3B15D9D1.21199@mta3 Whole thread Raw
Responses	Re: SQL( "if ...exists...),how to do it in the PostgreSQL? (Peter Eisentraut <peter_e@gmx.net>)
List	pgsql-hackers

Tree view

��    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

pgsql-hackers by date:

From: Tod McQuillin
Date: 05 June 2001, 19:47:33
Subject: Re: [GENERAL] Re: extra syntax on INSERT

From: Peter Eisentraut
Date: 05 June 2001, 20:18:31
Subject: Can the backend return more than one error message per PQexec?

SQL( "if ...exists...),how to do it in the PostgreSQL? - Mailing list pgsql-hackers

Previous

Next