Re: using pl/pgsql

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