Named column in a Function fails at ORDER BY (PgSQL 7.1)

Поиск
Список
Период
Сортировка
От Bernd von den Brincken
Тема Named column in a Function fails at ORDER BY (PgSQL 7.1)
Дата
Msg-id 5.1.0.14.2.20020403211109.01cf5e40@pop.kundenserver.de
обсуждение исходный текст
Ответы Re: Named column in a Function fails at ORDER BY (PgSQL 7.1)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Hello,
on the occasion of a subselect I found a behavior in PostgreSQL 7.1 that I 
consider faulty, but would like to hear comments before complaining to the 
hackers:

It seems that pgsql can not use a named result column in a function for 
ORDER BY. The same named result column can be used in an ORDER BY clause a) 
directly, _without_ the function or b) _with_ the same function but with 
the _original_ column name.

Here is the example - this fails with "ERROR: Attribute 'max_date' not found":
SELECT content, datetime AS max_date             FROM cftext        ORDER by date_part('hour', max_date)

Whereas this works both:
a)     SELECT content, datetime AS max_date             FROM cftext        ORDER by  max_date

b)    SELECT content, datetime AS max_date             FROM cftext        ORDER by date_part('hour', datetime)

Now in this example the alternative works fine, but if you use a Sub-SELECT 
there is no alternative to a named result column. I posted the simple 
example here to focus on the issue.
- Thanks for any hints -
// Bernd vdB



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

Предыдущее
От: Timothy_maguire@hartehanks.com
Дата:
Сообщение: Re: bytea or large object
Следующее
От: Michael Adler
Дата:
Сообщение: FULL JOIN with 3 or more tables