Returning a value from an update or insert using DBD::Pg - Mailing list pgsql-novice

From Barry Hoggard
Subject Returning a value from an update or insert using DBD::Pg
Date
Msg-id 20010714225224.B2272@panix.com
Whole thread Raw
List pgsql-novice
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


pgsql-novice by date:

Previous
From: Henry House
Date:
Subject: Re: Cast question (NULL -> NUMERIC)
Next
From: Henry House
Date:
Subject: GROUP BY and aggregate functions