returning does not act as expected after viewing documentation

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема returning does not act as expected after viewing documentation
Дата
Msg-id 156926087407.1118.10468521588901274687@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: returning does not act as expected after viewing documentation  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/dml-returning.html
Description:

With the following query:

update batch_log
set status=('in-progress'),
updated_at=now()
where status = ('pending')
and id = (
select id
  from batch_log
  where status = ('pending')
  order by priority desc, updated_at asc
  limit 1
)
returning id, batch_log.update_at
;


I get the following error message:


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.

I am on PostgreSQL 11 latest official docker image as of today's date
(2019-09-23).

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: @> (contains)
Следующее
От: Umberto
Дата:
Сообщение: Re: invalid ldconfig [option]