pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
user defined function question
3+ messages / 3 participants
[nested] [flat]

* user defined function question
@ 2001-08-15 03:34 Joseph Syjuco <joseph@asti.dost.gov.ph>
  2001-08-20 17:51 ` RE: user defined function question Robert J. Sanford, Jr. <rsanford@nolimitsystems.com>
  2001-08-20 18:14 ` Re: user defined function question Josh Berkus <josh@agliodbs.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Joseph Syjuco @ 2001-08-15 03:34 UTC (permalink / raw)
  To: pgsql-sql

how do i return a resultset from a user defined function. pls show a simple
structure




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* RE: user defined function question
  2001-08-15 03:34 user defined function question Joseph Syjuco <joseph@asti.dost.gov.ph>
@ 2001-08-20 17:51 ` Robert J. Sanford, Jr. <rsanford@nolimitsystems.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Robert J. Sanford, Jr. @ 2001-08-20 17:51 UTC (permalink / raw)
  To: Joseph Syjuco <joseph@asti.dost.gov.ph>; pgsql-sql

you can't.

rjsjr

> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Joseph Syjuco
> Sent: Tuesday, August 14, 2001 10:34 PM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] user defined function question
> 
> 
> how do i return a resultset from a user defined function. pls 
> show a simple
> structure
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: user defined function question
  2001-08-15 03:34 user defined function question Joseph Syjuco <joseph@asti.dost.gov.ph>
@ 2001-08-20 18:14 ` Josh Berkus <josh@agliodbs.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Josh Berkus @ 2001-08-20 18:14 UTC (permalink / raw)
  To: Joseph Syjuco <joseph@asti.dost.gov.ph>; +Cc: pgsql-sql

Joseph,

> how do i return a resultset from a user defined function. pls show a
> simple
> structure

As of version 7.1.x, you cannot return rowsets from a function.  This
feature will be available for future versions.

A number of workarounds have been posted to the list in past months.
Browse through and you should find them.

-Josh Berkus



______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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-08-20 18:14 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-08-15 03:34 user defined function question Joseph Syjuco <joseph@asti.dost.gov.ph>
2001-08-20 17:51 ` Robert J. Sanford, Jr. <rsanford@nolimitsystems.com>
2001-08-20 18:14 ` Josh Berkus <josh@agliodbs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox