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

Re: getting value of just inserted rows

From: lexx_h(at)chat(dot)ru
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: getting value of just inserted rows
Date: 2002-04-23 06:53:56
Message-ID: E16zuBY-0007mZ-00@mail.chat.ru (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(dot)Prenosil(at)finteh(dot)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),
>> 
>> ---> 

In response to

Responses

pgsql-interfaces by date

Next:From: Andreas KretzerDate: 2002-04-23 08:51:46
Subject: Re: Beginner Programming Question
Previous:From: Tom LaneDate: 2002-04-22 17:51:28
Subject: Re: ERROR: No such attribute or function 'oid'

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