Thread: getting value of just inserted rows
Hello all. Please, help me, How can I get single field (attribute) value just inserted new row into the table (by not using select query to find this row)? (type of that field is serial), --- lexx
But Postgresql doesn't support all SQL99 standart, so there is missing such terms as OLD and NEW ,REFERENCING OLD ROW AS..!! "Darko Prenosil" <Darko.Prenosil@finteh.hr> wrote: >Create insert trigger and look in the NEW ! > > >----- Original Message ----- >> >> >> Hello all. >> Please, help me, >> >> How can I get single field (attribute) value just inserted new row >> into the table (by not using select query to find this row)? >> >> (type of that field is serial), >> >> --->
> >> How can I get single field (attribute) value just inserted new row > >> into the table (by not using select query to find this row)? > >> > >> (type of that field is serial), Why not using select query? Use oid from last install and select by oid is the best way IMHO -- @BABOLO http://links.ru/