Assuming you have table foo with a sequence foo_seq, you can do this:
insert into foo (fields) values (....)
insert into bar (fields) select foo_seq.currval, ....
In other words, foo_seq.currval will always return the last value used by
your transaction.
-alex
On Mon, 4 Jun 2001, Tomas Eriksson wrote:
> Hi.
>
> I haven't seen any documentation about this, how do you use variables in a
> simple way in postgresql? I want to use same sequence number in a dynamic
> query from Perl.
>
> When i'm using MSSQL i can do like this in a single query
>
> "DECLARE @owner INT
> INSERT maintable (fields) VALUES (...)
> SELECT @owner = @@IDENTITY
> INSERT subtable (fields) VALUES (@owner, ...)"
>
> How does I save a value and using it later in the query..?
>
> kind regards
> Tomas
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>