pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedgetting value of just inserted rows
4+ messages / 2 participants
[nested] [flat]
* getting value of just inserted rows
@ 2002-04-19 13:21 lexx_h@chat.ru
0 siblings, 0 replies; 4+ messages in thread
From: lexx_h@chat.ru @ 2002-04-19 13:21 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* getting value of just inserted rows
@ 2002-04-19 13:32 lexx_h@chat.ru
2002-04-23 06:53 ` Re: getting value of just inserted rows lexx_h@chat.ru
0 siblings, 1 reply; 4+ messages in thread
From: lexx_h@chat.ru @ 2002-04-19 13:32 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: getting value of just inserted rows
2002-04-19 13:32 getting value of just inserted rows lexx_h@chat.ru
@ 2002-04-23 06:53 ` lexx_h@chat.ru
2002-04-24 00:01 ` Re: getting value of just inserted rows .@babolo.ru
0 siblings, 1 reply; 4+ messages in thread
From: lexx_h@chat.ru @ 2002-04-23 06:53 UTC (permalink / raw)
To: 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.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),
>>
>> --->
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: getting value of just inserted rows
2002-04-19 13:32 getting value of just inserted rows lexx_h@chat.ru
2002-04-23 06:53 ` Re: getting value of just inserted rows lexx_h@chat.ru
@ 2002-04-24 00:01 ` .@babolo.ru
0 siblings, 0 replies; 4+ messages in thread
From: . @ 2002-04-24 00:01 UTC (permalink / raw)
To: pgsql-interfaces
> >> 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/
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2002-04-24 00:01 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-19 13:21 getting value of just inserted rows lexx_h@chat.ru
2002-04-19 13:32 getting value of just inserted rows lexx_h@chat.ru
2002-04-23 06:53 ` lexx_h@chat.ru
2002-04-24 00:01 ` .@babolo.ru
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox