Host variable in subqueries

From: "Raginsky Alexander" <shasha(at)techst02(dot)technion(dot)ac(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: Host variable in subqueries
Date: 2001-05-29 20:08:47
Message-ID: 9f0s55$bkf$1@news.huji.ac.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello
We've got a question regarding the using of the host variables inside
subquery in declaration of cursor. Is there any restriction about it? We
had
problem in the following cursor:

EXEC SQL DECLARE ACQ CURSOR FOR
SELECT Id FROM
(SELECT SKey,CheckIn,CheckOut
FROM Stayed
WHERE Id= :given_id ) TheMan, Stayed
WHERE TheMan.SKey=Stayed.SKey AND TheMan.CheckIn=Stayed.CheckIn AND
TheMan.CheckOut=Stayed.CheckOut;

When we change :given_id to 9675467 (its real value) it works properly.
Do you have any idea what the problem is?

Thanks in advance.
Alexander & Yuri

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2001-05-29 20:12:11 Re: Fresh Installation of 7.1.1 RPMs = no binding to a port
Previous Message Stephan Szabo 2001-05-29 19:45:41 Re: Modifying a table that other tables refer to for foreigh key