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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
