From: | "Sim Zacks" <sim(at)compulab(dot)co(dot)il> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to return a record and sets of record in plpython |
Date: | 2005-03-30 06:42:20 |
Message-ID: | d2dhrv$1tkc$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
As far as I understand, though I hope someone will post that I'm wrong,
plpython cannot return recordsets.
In general, I use plpgsql when I want recordets and plpython when I want
functionality.
I have also called plpython functions from a plpgsql function when I wanted
a single value result.
"RL" <rlhsiao(at)gmail(dot)com> wrote in message
news:qKa2e(dot)5737$zl(dot)2948(at)newssvr13(dot)news(dot)prodigy(dot)com(dot)(dot)(dot)
> Hi,
>
> I am trying to implement a few functions in Plpython (in Postgresql
8.0.1).
> However, I could find the solution in the documentation, so I would
appreciate
> your help. My question is how to return a record and sets of records in
Plpython
> if it's possible. For instance, if we have a table name EMP
>
> CREATE TABLE EMP ( name text, salary integer, age integer )
>
> according to the documentation, the following code will return a composite
> type:
>
> CREATE FUNCTION new_emp() RETURNS EMP AS '
> SELECT text "None" AS name,
> 1000 AS salary,
> 25 AS age;
> ' LANGUAGE SQL;
>
> and
>
> "RETURN NEXT" in Pl/pgsql allows us to return multiple rows
>
> How am I going to do the same thing in plpython?
> Thanks,
>
> Ruey-Lung Hsiao
From | Date | Subject | |
---|---|---|---|
Next Message | Shaun Clements | 2005-03-30 07:11:09 | Postgres mystery |
Previous Message | Bruce Momjian | 2005-03-30 06:36:45 | Re: 8.0.2beta1 |