connecting inside pl/pgsql

On Monday 16 Sep 2002 10:45 pm, Edwin Grubbs wrote:

Is there any way to connect to a different database inside a pl/pgsql
function? Apparently, this is possible in Oracle PL/SQL, and it would be
useful for porting that code.

If it is not possible, are there any plans to add this?

You should investigate the contrib/dblink directory in the source
distribution.

- Richard Huxton

Richard Huxton wrote:

On Monday 16 Sep 2002 10:45 pm, Edwin Grubbs wrote:

Is there any way to connect to a different database inside a pl/pgsql
function? Apparently, this is possible in Oracle PL/SQL, and it would be
useful for porting that code.

If it is not possible, are there any plans to add this?

You should investigate the contrib/dblink directory in the source
distribution.

It is possible in PL/TclU. There are currently no plans to add it
to PL/pgSQL.

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being
right. #
# Let's break this rule - forgive
me. #
#==================================================
JanWieck@Yahoo.com #