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

"Ben-Nes Michael" <miki@canaan.co.il> writes:
> The following line works:
> SELECT * INTO lft_rgt FROM forum_tree WHERE node_id = v_node_id;
> RETURN lft_rgt.f_id;
> The following lines dont work ( variable get mixed ), lft_rgt.f_id return
> lft_rgt.rgt :(
> SELECT lft, rgt, f_id INTO lft_rgt FROM forum_tree WHERE node_id =
> v_node_id;
> RETURN lft_rgt.f_id;

If this is meant as a bug report, it is entirely useless.  Please give a
complete, standalone example that someone else can run to reproduce the
problem.  You can't expect us to guess our way to all the context
involved in this query.

The bug reporting guidelines in the User's Guide
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/bug-reporting.html
are a tad verbose but are worth reading.

            regards, tom lane