Postgres Pro
Downloads
Home   >   mailing lists

Re: How does one return rows from plpgsql functions? - Mailing list pgsql-general

From Tom Lane
Subject Re: How does one return rows from plpgsql functions?
Date
Msg-id 22554.1011469687@sss.pgh.pa.us
Whole thread Raw
In response to How does one return rows from plpgsql functions?  (Ryan Kirkpatrick <pgsql@rkirkpat.net>)
Responses Re: How does one return rows from plpgsql functions?  (Ryan Kirkpatrick <pgsql@rkirkpat.net>)
List pgsql-general
Tree view 
Ryan Kirkpatrick <pgsql@rkirkpat.net> writes:
> I get the field data? I tried "SELECT update_get(1).id;" but that gives a
> syntax error.

Yeah, that's something we ought to allow.  Maybe for 7.3.

> And "SELECT id(update_get(1));" rewards me with a backend
> crash. :(

Works okay for me in current sources.  Time to update ...

            regards, tom lane

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: large file limitation
Next
From: Sean Chittenden
Date:
Subject: Re: "IS NOT NULL" != "NOT NULL"