Le 08/12/2010 11:04, Manasi Save a écrit :
> Also I want to query multiple databases from stored functions from one
> central database.
> for ex :=
>
> CREATE OR REPLACE FUNCTION test () RETURNS AS
> $BODY$
>
> SELECT * FROM db2.volume
> ORDER BY db2.volume.volumeID
>
> $BODY$
> LANGUAGE sql STABLE
> COST 100
> ROWS 1000;'
>
> I have implemented this thing in mysql but I am not really sure is it
> possible in postgresql.
Nope, you can't use the same kind of queries. You need to install dblink
or PL/proxy to get that kind of capacity.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com