Re: Returning data from function - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Returning data from function
Date
Msg-id web-496050@davinci.ethosmedia.com
Whole thread Raw
In response to Returning data from function  ("Sharon Cowling" <sharon.cowling@sslnz.com>)
Responses Re: Returning data from function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Sharon,

> I've mainly worked with Oracle in the past, so I need your help with
> this:
> I'm creating the code for web based reports for a client.  I need to
> recieve
> parameters
> and return a resultset.

This functionality does not currently work in PostgreSQL.  Some form of
rowset-returning functions are expected for ver. 7.2 (any week now,
really ...) but I'm not certain they will do waht you want.

For more discussion, check the archives of the PGSQL-SQL list, where
this topic has surfaced multiple times.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

pgsql-novice by date:

Previous
From: "Sharon Cowling"
Date:
Subject: Returning data from function
Next
From: "Sharon Cowling"
Date:
Subject: Update function