Re: INSERT INTO...RETURNING vs SELECT

Поиск
Список
Период
Сортировка
От Cliff Wells
Тема Re: INSERT INTO...RETURNING vs SELECT
Дата
Msg-id 1270482024.4749.161.camel@portable-evil
обсуждение исходный текст
Ответ на Re: INSERT INTO...RETURNING vs SELECT  (Andreas Kretschmer <akretschmer@spamfence.net>)
Список pgsql-sql
On Mon, 2010-04-05 at 09:10 +0200, Andreas Kretschmer wrote:
> Cliff Wells <cliff@develix.com> wrote:
> 
> > As far as I can see, INSERT INTO...RETURNING is semantically equivalent
> > to SELECT...FROM with a side-effect, so it seems this construct should
> > work.  Can someone shed some light?
> 
> Well, at the moment you can't reuse the RETURNING-values, you have to
> wait for 9.1, writeable CTE.

Thanks, I just wanted to make sure I wasn't misunderstanding something.

Regards,
Cliff



В списке pgsql-sql по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: INSERT INTO...RETURNING vs SELECT
Следующее
От: junaidmalik14
Дата:
Сообщение: count function alternative in postgres