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

Hi All

I think i found the problem to my previous thread.

Since upgrading to 7.3.2 from 7.3.1 im having the following problem.


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;


Any ideas ?
maybe bug ?



--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://sites.canaan.co.il
--------------------------