Re: Call function with dynamic schema name - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: Call function with dynamic schema name
Date
Msg-id CAFj8pRDkMZ3vyFz9-dGJdp2YA5ckiJ0a4Fa1TLw9TOkDu2jZLQ@mail.gmail.com
Whole thread Raw
In response to Re: Call function with dynamic schema name  (IlGenna <alessio.gennari78@gmail.com>)
List pgsql-sql
2012/1/15 IlGenna <alessio.gennari78@gmail.com>:
> Can you provide me e little example plz?

CREATE SCHEMA s1;
CREATE SCHEMA s2;

CREATE TABLE s1.a1(a int);
CREATE TABLE s2.a1(a int);

CREATE OR REPLACE FUNCTION s1.fx1()
RETURNS int AS $$ BEGIN RETURN (SELECT MAX(a) FROM s1.a1); END
$$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION s2.fx1()
RETURNS int AS $$ BEGIN RETURN (SELECT MAX(a) FROM s2.a1); END
$$ LANGUAGE plpgsql;

SET search_path TO s1;
SELECT fx1(); -- returns max from s1.a1;

SET search_path TO s2;
SELECT fx1(); -- returns max from s2.s1;

Regards

Pavel Stehule

>
> Thanks in advance.
>
> Alessio
>
> --
> View this message in context:
http://postgresql.1045698.n5.nabble.com/Call-function-with-dynamic-schema-name-tp5146721p5146739.html
> Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql


pgsql-sql by date:

Previous
From: IlGenna
Date:
Subject: Re: Call function with dynamic schema name
Next
From: Alok Thakur
Date:
Subject: sql query problem