Re: BUG #6774: FOR IN SELECT LOOP ignores ORDER BY

Поиск
Список
Период
Сортировка
От Boris Folgmann
Тема Re: BUG #6774: FOR IN SELECT LOOP ignores ORDER BY
Дата
Msg-id jv5lok$1bmr$1@news.hub.org
обсуждение исходный текст
Ответ на Re: BUG #6774: FOR IN SELECT LOOP ignores ORDER BY  (hubert depesz lubaczewski <depesz@depesz.com>)
Ответы Re: BUG #6774: FOR IN SELECT LOOP ignores ORDER BY  (Jan Wieck <JanWieck@Yahoo.com>)
Список pgsql-bugs
Hi,

hubert depesz lubaczewski schrieb/wrote:
> generally - order by datname is understood as "order by *variable
> datname*". - which is null.

It's clear that it's a shadowing problem. But it's not a "FOR IN EXECUTE"
where a variable makes sense. I mean why is a "ORDER BY variable" valid in
"FOR IN"? In SQL you can't use ORDER BY NULL. If the order by clause is not
correct the whole statement should raise an error.

Tnx,
       Boris

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

Предыдущее
От: andervalbh@gmail.com
Дата:
Сообщение: BUG #6785: Memory Leak in plpgsql
Следующее
От: "Emcisc (JinWei) Zhao"
Дата:
Сообщение: Error on pg_settings.bytea_output for pg9.1