plpgsql mixing variable in SELECT INTO ?

From: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
To: "postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: plpgsql mixing variable in SELECT INTO ?
Date: 2003-03-03 12:04:17
Message-ID: 002301c2e17d$042a5540$aa0f5ac2@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
--------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-03-03 12:48:42 Re: wal-debug
Previous Message Munteanu Gabriel 2003-03-03 11:11:37 Re: wal-debug