getting a timestamp (or other value) back from an SQL UPDATE statement

[Dr. Hawkins]

On Sun, Aug 11, 2013 at 3:50 PM, Peter Haworth <pete at lcsql.com> wrote:
> On Sun, Aug 11, 2013 at 1:16 PM, Dr. Hawkins <dochawk at gmail.com> wrote:
>
>>  UPDATE myindex SET tmstmp=NOW() RETURNING tmstmp;
>
>
> Just do SELECT tmstmp FROM myIndedx right after the UPDATE and before the
> END.and get rid of the RETURNING clause

That's what I'm doing right now--and trying to avoid.  It gives me the
full latency lag twice, at several hundred milliseconds each!


-- 
Dr. Richard E. Hawkins, Esq.
(702) 508-8462