Re: Return SETOF or array from pl/python - Mailing list pgsql-general

From Peter Fein
Subject Re: Return SETOF or array from pl/python
Date
Msg-id 42D836E3.50503@pobox.com
Whole thread Raw
In response to Re: Return SETOF or array from pl/python  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Joshua D. Drake wrote:

> You would actually have to have a set. What I believe you are trying to
> do is transform a list to a result set. I don't think you can do that
> without some additional programming within the function.
>
> Somebody may know of a better way but what I would think would happen is
> this:
>
> Break up list, insert each value of list into a temp table as a row,
> return set of temp table.

Is there a way to represent a set of constant rows in SQL, aside from
creating a temp table & populating it?  I've had need of this before -
IIRC, something was mentioned about the SQL VALUES construct being
unimplemented.

--
Peter Fein                 pfein@pobox.com                 773-575-0694

Basically, if you're not a utopianist, you're a schmuck. -J. Feldman

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: how to insert '\\' in postgres database using java
Next
From: "Thomas F. O'Connell"
Date:
Subject: Re: ERROR: could not open relation