RE: Returning a value from insert/update with DBD::Pg

[Sterin, Ilya]

What are you trying to do.  Placeholder binding?  Are you asking if you can
run such a query?   I don't see anything specific to Oracle here, unless
DBD::Pg does not support named placeholder, then you will have to use ?
instead of :1

Ilya

-----Original Message-----
From: Barry Hoggard
To: [EMAIL PROTECTED]
Sent: 07/16/2001 10:42 AM
Subject: Returning a value from insert/update with DBD::Pg

I know in Oracle I do something like this:

my $sth = $self->dbh->prepare(qq{ update users set
                                  valid=0,end_date=sysdate
                                  where id='$self->{id}' returning
                                  $end_date
                                  into :1});

Is this possible with DBD::Pg?



-- 
Barry Hoggard