Re: Return the primary key of a newly inserted row?

From: Kenneth Downs <ken(at)secdat(dot)com>
To: Tim Allen <tim(at)proximity(dot)com(dot)au>
Cc: John Tregea <john(at)debraneys(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Return the primary key of a newly inserted row?
Date: 2006-06-22 11:26:14
Message-ID: 449A7E56.7020100@secdat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
ken.vcf text/x-vcard 186 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Downs 2006-06-22 11:38:35 Re: Form builder?
Previous Message Kenneth Downs 2006-06-22 11:24:11 Re: Return the primary key of a newly inserted row?