Re: Return the primary key of a newly inserted row? - Mailing list pgsql-general

From Kenneth Downs
Subject Re: Return the primary key of a newly inserted row?
Date
Msg-id 449A7E56.7020100@secdat.com
Whole thread Raw
In response to Re: Return the primary key of a newly inserted row?  (Tim Allen <tim@proximity.com.au>)
Responses Re: Return the primary key of a newly inserted row?
List pgsql-general
Tim Allen wrote:

>
> using syntax along the lines of INSERT ... RETURNING ...
>
SQL Server had a nifty feature here.  You could simply toss a SELECT
statement at the end of a trigger of sproc and the results would be
returned.

This in effect made a table the potential return type of all commands,
which could be exploited very powerfully.

Do the hackers have any thoughts along those lines?

Attachment

pgsql-general by date:

Previous
From: Kenneth Downs
Date:
Subject: Re: Return the primary key of a newly inserted row?
Next
From: Kenneth Downs
Date:
Subject: Re: Form builder?