Re: order by is ambiguous
От | Travel Jadoo |
---|---|
Тема | Re: order by is ambiguous |
Дата | |
Msg-id | 1073582450.11264.30.camel@server обсуждение исходный текст |
Ответ на | Re: order by is ambiguous (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: order by is ambiguous
|
Список | pgsql-general |
On Thu, 2004-01-08 at 16:09, Tom Lane wrote: > Travel Jadoo <jadoo@xs4all.nl> writes: > > I could not find any discussion on this but imho this seems an erroneous > > error occuring now in 7.3.4 (after upgrade from 7.2.3): > > > select null::time, 'test'::varchar as time order by time; > > ERROR: ORDER BY 'time' is ambiguous > > What's erroneous about it? You have two output columns named 'time'. > > regards, tom lane Hmm but the first one has actually no name, it's just casted as datatype time. I now realise that casted columns get assigned the datatype as name. Should it not show ?column? as output just like you a "select null;" would do? This actually came up as I have multiple time fields but only one was named time by me. Regards, Alfred
В списке pgsql-general по дате отправления: