On Wed, 2004-06-16 at 19:05, Paul Thomas wrote:
> On 16/06/2004 21:27 Robert Fitzpatrick wrote:
> > I have plperl installed my PostgreSQL 7.4.2 server, but from what I
> > understand in chapter 39.3 of the docs, you cannot access the databases
> > without DBD::PgSPI. According to the readme for that module, it will
> > only run on the untrusted plperlu.
> >
> > Is this the only way to run queries (SELECT, INSERT, UPDATE) using
> > plperl?
>
> Are you talking about writing functions/stored procedures in PERL or
> accessing the database from a PERL program because what you have read is
> specific to functions/stored procedures. (sorry for the bad/absent
> punctuation but I've just come back from the pub after a generous quantity
> of Old Speckled Hen)
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.
--
Robert
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
