From: | "Tomas Eriksson" <tomas(at)embryo(dot)se> |
---|---|
To: | "Alex Pilosov" <alex(at)pilosoft(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Re: Variables in Postgresql |
Date: | 2001-06-11 15:15:24 |
Message-ID: | 02b001c0f289$573c39e0$410010ac@embryo.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for you answer. In that case it works fine with the sequence function. Just to handle simple values between select-statements, variables is very useful. What I have seen this is only possible in pl/pgsql and I don't want to create a function of everything.
/Tomas
----- Original Message -----
From: "Alex Pilosov" <alex(at)pilosoft(dot)com>
To: "Tomas Eriksson" <tomas(at)embryo(dot)se>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Monday, June 11, 2001 3:31 PM
Subject: Re: [GENERAL] Variables in Postgresql
> 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(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
> >
> >
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ted | 2001-06-11 15:16:46 | Re: New 7.1.2 RPMS -- 7.1.2-2.PGDG |
Previous Message | Tatsuo Ishii | 2001-06-11 14:42:02 | Re: Yet another Postgresql article... |