Re: using pl/pgsql

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Antoine <asolomon15(at)nyc(dot)rr(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: using pl/pgsql
Date: 2003-05-09 15:27:04
Message-ID: 200305090827.04764.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Antoine,

> Hello all I would like to create a pl/pgsql function that can handle a
> query that will work on different schemas.

Shouldn't be a problem if the function is set to run as the superuser.

> But I am not sure about the
> RECORD type and if I can return more then one row. could PL/pgsql
> return more then 1 row from the database.

Starting with version 7.3.x, yes. See:
http://techdocs.postgresql.org/guides/SetReturningFunctions

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Terence Ng 2003-05-10 02:48:37 Multilingual database
Previous Message Dani Oderbolz 2003-05-09 08:29:51 Re: JOINS...