Re: plpgsql mixing variable in SELECT INTO ?

well i coded select into lft_rgt rgt from forum_tree where bla bla;

This was code i implented at 7.2.x and rgt suposed to tell me how to push a
nested set model of tree ( Joe Celko Model )

I had to fix the "rgt" to "*" after i updated to 7.3.2

--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://sites.canaan.co.il
--------------------------
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
Cc: "postgresql" <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, March 04, 2003 7:45 PM
Subject: Re: [GENERAL] plpgsql mixing variable in SELECT INTO ?

> "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il> writes:
> > You mean I cant use the full power of the SELECT as mentioned in the
manual
> > and when using SELECT INTO I must use * and I can refine my query to
some of
> > the fields ?
>
> Certainly you can. But when you assign into a row variable, you have to
> provide all the row variable's columns, in order. How else would you
> expect it to work?
>
> > Also its quite strange that my code worked in 7.3.1-
>
> I don't believe it.
>
> regards, tom lane
>
> ---------------------------(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
>