Postgres Pro
Downloads
Home   >   mailing lists

Need to select and update with the same sql statement - Mailing list pgsql-php

From David Busby
Subject Need to select and update with the same sql statement
Date
Msg-id 026501c28b4a$fe1a1c40$4000000a@busbydev
Whole thread Raw
Responses Re: Need to select and update with the same sql statement
List pgsql-php
Tree view 
List,
    I need to do a command like:

    select * from "table" where "id"=54; update "table" set "col"=value
where "id"=just selected id

    Is that possible?  How would I work that into a StoredProcedure? I'm
getting a race condition where two+ clients are asking for data but getting
the same record, (each record is a datachunk for a distributed client).
This results in each client working on the same data, not good.  Any ideas?
I'm posting to the php/sql list cause the clients ask for the datachunk via
SOAP request that is processed via PHP.  Any assistance would be great

/B

pgsql-php by date:

Previous
From: "Fernando Papa"
Date:
Subject: Retriving cursor from pgplsql function
Next
From: "scott.marlowe"
Date:
Subject: Re: Need to select and update with the same sql statement