Bug: aliasing in ORDER BY when UNIONing

Поиск
Список
Период
Сортировка
От Marko Kreen
Тема Bug: aliasing in ORDER BY when UNIONing
Дата
Msg-id 20010219025357.A3588@l-t.ee
обсуждение исходный текст
Ответы Re: Bug: aliasing in ORDER BY when UNIONing
Список pgsql-hackers
What works:

# select o.id from op o order by o.id;
# select o.id from op o union all SELECT -1 order by id;

Does not work:

# select o.id from op o union all SELECT -1 order by o.id;
ERROR:  Relation 'o' does not exist
# select o.id from op o union all SELECT -1 from op o order by o.id;
ERROR:  Relation 'o' does not exist


Running today's CVS.  (I finally converted my main workstation
to 7.1...)

-- 
marko



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