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

[Peter Haworth]

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

Pete
lcSQL Software <http://www.lcsql.com>