Thread: PL/Perl questions...

PL/Perl questions...

From
"LLC"
Date:
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...
 

Re: PL/Perl questions...

From
David Fetter
Date:
On Fri, Jun 16, 2006 at 11:42:51AM -0500, LLC wrote:
> 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)";

DBI-Link does something a lot like this.
http://pgfoundry.org/projects/dbi-link/

> 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?

See above :)

Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!