Re: [INSERT]Return a value

Поиск
Список
Период
Сортировка
От Leví Teodoro da Silva
Тема Re: [INSERT]Return a value
Дата
Msg-id 4a74ba520811070549k4c10f272ye5660a8e23e6e7aa@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [INSERT]Return a value  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Ответы Re: [INSERT]Return a value  (Andreas Kretschmer <akretschmer@spamfence.net>)
Список pgsql-novice
Andreas,

I dont want to insert the values that the first insert returned in the second insert, i just want to receive the return value from the first query and after i want to execute a different query not related with the first. Is it not possible !?

Thanks,
Leví

2008/11/7 A. Kretschmer <andreas.kretschmer@schollglas.com>
am  Fri, dem 07.11.2008, um 11:21:05 -0200 mailte Leví Teodoro da Silva folgendes:
> Hi guys,
>
> I was looking for something like the follow but i dont get ...
>
> I want to do two inserts. In my first insert i want that the query returns a
> result for me and in the second, i want that the postgres just insert the
> values in my table.

IIRC, you can't use the RETURNING value for a neu INSERT, it is a TODO
for the next release.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: [INSERT]Return a value
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [INSERT]Return a value