Re: How does one return rows from plpgsql functions?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ryan Kirkpatrick <pgsql(at)rkirkpat(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How does one return rows from plpgsql functions?
Date: 2002-01-19 19:48:07
Message-ID: 22554.1011469687@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ryan Kirkpatrick <pgsql(at)rkirkpat(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sean Chittenden 2002-01-19 21:19:13 Re: "IS NOT NULL" != "NOT NULL"
Previous Message Andrew Sullivan 2002-01-19 18:48:02 Re: large file limitation