Re: Database accesss using plperl

Further to my earlier email: the CommandPrompt
pl/perl appears to handle trigger functions, but not
direct database access? Someone correct me if I'm
wrong.

So DBI:PgSPI may still be the only way to query the
database from a function using Perl. But are you sure
you really have to use Perl? If you are looking for a
language other than pl/pgsql to do queries from
functions, look at pl/tcl; I think that pl/python and
pl/ruby may also have some capability to do what you
want.

--- Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> wrote:
> On 17/06/2004 15:56 Robert Fitzpatrick wrote:
> > [snip]
> > I'm talking about writing PostgreSQL stored
> procedures using Perl that
> > access the database via queries (like pl/pgsql,
> maybe using DBI:Pg) for
> > SELECTs, INSERTs, UPDATEs, etc.
>
> Then DBI:PgSPI is what you want. AFAIK, DBI:Pg is
> for client-side only.
>
> HTH
>
> --
> Paul Thomas
>
+------------------------------+---------------------------------------------+
> | Thomas Micro Systems Limited | Software Solutions
> for
> Business |
> | Computer Consultants |
> http://www.thomas-micro-systems-ltd.co.uk |
>
+------------------------------+---------------------------------------------+
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
>

__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail