Re: plpgsql mixing variable in SELECT INTO ?

Hi

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 ?

Also its quite strange that my code worked in 7.3.1-

Cheers
--------------------------
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 5:16 PM
Subject: Re: [GENERAL] plpgsql mixing variable in SELECT INTO ?

> "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il> writes:
> > so it seems that order does matter and one canot ommit the first field
in
> > the table structure.
>
> What's surprising about that? That's exactly how it *should* work, IMHO.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>