PL/Perl questions... - Mailing list pgsql-general

From LLC
Subject PL/Perl questions...
Date
Msg-id 1150476171.v2.fusewebmail-164106@f
Whole thread Raw
Responses Re: PL/Perl questions...
List pgsql-general
Hi List;
 
I have 2 questions...
 
1) I want to create a perl function which connects to an external non-Postgres database and retrieves data. I wonder is the best way to do this to return a set or an array? I assume returning a data set is a better way to go, I want to be able to run something like this:
 
"select a,b,c from my_new_perl_func('odbc-conn', 'sql-string') as t1(a,b,c)";
 
2) can anyone provide me with an example of how to return data from a perl function in this manner based on a DBI query?
 
Thanks in advance for your help...
 

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Question about clustering multiple columns
Next
From: Chander Ganesan
Date:
Subject: Re: Omitting tablespace creation from pg_dumpall...