Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: get id of insert in plpgsql function
- From: "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
- To: pgsql-novice(at)postgresql(dot)org
- Subject: Re: get id of insert in plpgsql function
- Date: Thu, 22 May 2008 10:03:57 +0200
- Message-id: <20080522080357(dot)GC27260(at)a-kretschmer(dot)de>
am Thu, dem 22.05.2008, um 9:56:49 +0200 mailte A B folgendes: > If I have a table mytable (id serial, y integer) and wish to insert a > row into the table in a plpgsql function, how can I catch the id > (serial number) of the last inserted row? Either with currval() oder with RETURNING. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
- References:
- get id of insert in plpgsql function
- From: A B
- get id of insert in plpgsql function
- Prev by Date: get id of insert in plpgsql function
- Next by Date: Re: recreating tables from global files
- Previous by thread: get id of insert in plpgsql function
- Next by thread: Re: get id of insert in plpgsql function
- Indexes: