Skip site navigation (1) Skip section navigation (2)

Re: Please advise features in 7.1 (SUMMARY)

From: "xuyifeng" <jamexu(at)telekbird(dot)com(dot)cn>
To: "John Huttley" <John(at)mwk(dot)co(dot)nz>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Please advise features in 7.1 (SUMMARY)
Date: 2000-11-30 02:50:32
Message-ID: 002201c05a78$56604920$e001a8c0@xyf (view raw or flat)
Thread:
Lists: pgsql-hackers
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
> 
> 
> 

In response to

Responses

pgsql-hackers by date

Next:From: Alain ToussaintDate: 2000-11-30 04:28:50
Subject: Re: beta testing version
Previous:From: Tom LaneDate: 2000-11-30 02:42:44
Subject: Re: RE: xlog_bufmgr

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group