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