Received: from mail.chat.ru (unknown [212.24.45.11]) by postgresql.org (Postfix) with ESMTP id 2979C47546E for ; Tue, 23 Apr 2002 02:59:15 -0400 (EDT) Received: from chat by mail.chat.ru with local (Exim 3.22 #14) id 16zuBY-0007mZ-00 for pgsql-interfaces@postgresql.org; Tue, 23 Apr 2002 10:53:56 +0400 From: lexx_h@chat.ru To: pgsql-interfaces@postgresql.org Errors-To: lexx_h@chat.ru Reply-To: lexx_h@chat.ru References: <000f01c1e7aa$7b251950$f600000a@darko> In-Reply-To: <000f01c1e7aa$7b251950$f600000a@darko> MIME-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 8bit X-Mailer: WebMail on Chat.ru X-IP-from: 193.124.163.244 X-IP-from2: [] Subject: Re: getting value of just inserted rows Message-Id: Date: Tue, 23 Apr 2002 10:53:56 +0400 X-Archive-Number: 200204/41 X-Sequence-Number: 2583 But Postgresql doesn't support all SQL99 standart, so there is missing such terms as OLD and NEW ,REFERENCING OLD ROW AS..!! "Darko Prenosil" 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), >> >> --->