Postgres Pro
Downloads
Home   >   mailing lists

select refcursor into a variable - Mailing list pgsql-general

From Madhavi
Subject select refcursor into a variable
Date
Msg-id NHBBINJKLKIANIDACONLCEGFCAAA.madhavi@zoniac.com
Whole thread Raw
Responses problem starting postgresql i.e postmaster  (suresh s <sureshatwork@yahoo.com>)
Re: select refcursor into a variable  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Postgresql -- initial impressions and comments
Next
From: "Clark C. Evans"
Date:
Subject: Anyone working on OLAP stuff?