Is "if" clause support in PG?
"drop table aa if exist"
"insert into aa values(1) if not exists select * from aa where i=1"
I would like PG support it.
----- Original Message -----
From: John Huttley <John(at)mwk(dot)co(dot)nz>
Sent: Tuesday, November 28, 2000 9:04 AM
Subject: [HACKERS] Please advise features in 7.1 (SUMMARY)
> Thanks for your help, everyone.
> This is a summary of replies.
> 1. Calculated fields in table definitions . eg.
> Create table test (
> A Integer,
> B integer,
> the_sum As (A+B),
> This functionality can be achieved through the use of views.
> Implementing the create table syntax may not be too hard,
> but not in 7.1...
> 2 Parameterised Triggers
> Functionality is there, just that the documentation gave the wrong implication.
> An user manual example of using parameterised triggers to implement referential
> would be welcome.
> 3. Stored Procedures returning a record set.
> Dream on!
In response to
pgsql-hackers by date
|Next:||From: Alain Toussaint||Date: 2000-11-30 04:28:50|
|Subject: Re: beta testing version|
|Previous:||From: Tom Lane||Date: 2000-11-30 02:42:44|
|Subject: Re: RE: xlog_bufmgr |