Postgres Pro
Downloads
Home   >   mailing lists

get id of insert in plpgsql function - Mailing list pgsql-novice

From A B
Subject get id of insert in plpgsql function
Date
Msg-id dbbf25900805220056n7826a97ek576095a3e9372b99@mail.gmail.com
Whole thread Raw
Responses Re: get id of insert in plpgsql function  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-novice
Tree view 
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?

pgsql-novice by date:

Previous
From: "G. J. Walsh"
Date:
Subject: recreating tables from global files
Next
From: "A. Kretschmer"
Date:
Subject: Re: get id of insert in plpgsql function