From: Anoop G <anoopmadavoor@gmail.com>
To: pgsql-sql@postgresql.org
Subject: how to returns set of records in PL/python
Date: Mon, 7 Apr 2008 18:17:22 +0530
Message-ID: <1a027d210804070547w3117f195qa279b487b896674d@mail.gmail.com> (raw)
Hi ,
Iam new to plpython,how can I return a recordset from a plpython
function?
Is there is any way give me an example;
plpgsql function
--------------------------------
CREATE OR REPLACE FUNCTION function_to_get_all_countries() RETURNS SETOF
RECORD AS $BODY$
DECLARE
r RECORD;
BEGIN
FOR r IN SELECT pk_bint_country_id,vchr_country FROM tbl_country LOOP
RETURN NEXT r;
END LOOP;
RETURN;
END
$BODY$ LANGUAGE 'plpgsql';
How i can get the same result using plpythonu and how I can call the
function (is there any user defined type required like in plpgsql)?
Thanks in advance
Anoop
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: anoopmadavoor@gmail.com
Subject: Re: how to returns set of records in PL/python
In-Reply-To: <1a027d210804070547w3117f195qa279b487b896674d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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