Re: Please advise features in 7.1 (SUMMARY)

Is "if" clause support in PG?
for example:
"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.
---
XuYifeng

----- Original Message -----
From: John Huttley <John(at)mwk(dot)co(dot)nz>
To: <pgsql-hackers(at)postgresql(dot)org>
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
> integrity
> would be welcome.
>
> 3. Stored Procedures returning a record set.
>
> Dream on!
>
>
> Regards
>
> John
>
>
>