Re: plpgsql mixing variable in SELECT INTO ? - Mailing list pgsql-general

"Ben-Nes Michael" <miki@canaan.co.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