On Mon, Sep 23, 2019 at 2:45 PM PG Doc comments form <[email protected]>
wrote:
> update batch_log
> set status=('in-progress'),
> updated_at=now()
> [...]
> returning id, batch_log.update_at
> ;
>
> column batch_log.update_at does not exist
> LINE 14: returning id, batch_log.update_at
> HINT: Perhaps you meant to reference the column "batch_log.updated_at".
>
> This does not make a whole lot of sense. It is recommending that I do what
> I
> am doing!
>
> Also I don't see why this would fail.
>
Its informing you, apparently correctly, of a possible typo in your query.
You wrote: returning ... "batch_log.update_at" but the spelling for that
field is in past tense "batch_log.updated_at" - note the "d" on the end of
the word "update".
David J.
