Re: returning does not act as expected after viewing documentation

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: returning does not act as expected after viewing documentation
Дата
Msg-id CAKFQuwa04KyBn1UKbvbQvBA8C2_qXxrxXLOYNYZVDu0tGNf2dg@mail.gmail.com
обсуждение исходный текст
Ответ на returning does not act as expected after viewing documentation  (PG Doc comments form <noreply@postgresql.org>)
Ответы Re: returning does not act as expected after viewing documentation  (lennart rolland <lennartrolland@gmail.com>)
Список pgsql-docs
Дерево обсуждения
On Mon, Sep 23, 2019 at 2:45 PM PG Doc comments form <noreply@postgresql.org> 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.

В списке pgsql-docs по дате отправления:

Предыдущее
От: Umberto
Дата:
Сообщение: Re: invalid ldconfig [option]
Следующее
От: lennart rolland
Дата:
Сообщение: Re: returning does not act as expected after viewing documentation