Re: RETURNING and DO INSTEAD ... Intentional or not?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: RETURNING and DO INSTEAD ... Intentional or not?
Date: 2007-09-12 17:58:01
Message-ID: 200709121058.02019.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom,

> What the RETURNING clause in the rule does is let you define the data
> that should be returned if the rewritten INSERT had a returning clause
> to start with.

Hmmm. Aha, that works:

postgres=# insert into test values ( 'mary' ) returning test1;
test1
-------
mary

So, this should probably be documented to avoid confusion like mine. Will
write something up ...

--
Josh Berkus
PostgreSQL @ Sun
San Francisco

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Huxton 2007-09-12 18:15:11 Re: RETURNING and DO INSTEAD ... Intentional or not?
Previous Message Tom Lane 2007-09-12 17:39:24 Re: RETURNING and DO INSTEAD ... Intentional or not?