Skip site navigation (1) Skip section navigation (2)

Re: [INSERT]Return a value

From: Leví Teodoro da Silva <tlevisilva(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [INSERT]Return a value
Date: 2008-11-07 13:49:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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 !?


2008/11/7 A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)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
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:

In response to


pgsql-novice by date

Next:From: Tom LaneDate: 2008-11-07 13:50:56
Subject: Re: [INSERT]Return a value
Previous:From: A. KretschmerDate: 2008-11-07 13:34:38
Subject: Re: [INSERT]Return a value

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group