Quick Links

select refcursor into a variable

From:	"Madhavi" <madhavi(at)zoniac(dot)com>
To:	<pgsql-general(at)postgresql(dot)org>
Subject:	select refcursor into a variable
Date:	2002-12-04 06:48:49
Message-ID:	NHBBINJKLKIANIDACONLCEGFCAAA.madhavi@zoniac.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hi all,
I'm executing dynamic queries in postgres7.2.3. Is there a way I can
execute a refcursor and then select it into a variable and then return that
variable? My query returns the sum of values. So its only one single
value...that I want to select into a variable. How do I do this. 'cos I
don't wnat to return a refcursor.

Thanx
Madhavi

Responses

problem starting postgresql i.e postmaster at 2002-12-04 09:43:17 from suresh s
Re: select refcursor into a variable at 2002-12-04 09:46:41 from Richard Huxton

Browse pgsql-general by date

	From	Date	Subject
Next Message	Clark C. Evans	2002-12-04 07:18:11	Anyone working on OLAP stuff?
Previous Message	Shridhar Daithankar	2002-12-04 06:48:14	Re: Postgresql -- initial impressions and comments