Re: Error with DISTINCT and AS keywords
От | Jean-Luc Lachance |
---|---|
Тема | Re: Error with DISTINCT and AS keywords |
Дата | |
Msg-id | 3D2C5121.C26FD800@nsd.ca обсуждение исходный текст |
Ответ на | Error with DISTINCT and AS keywords (Andreas Schlegel <schlegel@software.b.uunet.de>) |
Список | pgsql-sql |
PostgreSQL does not know how to sort 'TEST'. You must help it be telling it what tpe it is. Add ::text after 'TEST' as in 'TEST'::text. Maybe PostgreSQL should default to text for unknown types... JLL Andreas Schlegel wrote: > > Hi, > > I need some help to let this sql statement run with Postgres 7.2.1 > > Doesn't work: > select DISTINCT tnr, titel, 'TEST' AS testcol from tTitel; > ERROR: Unable to identify an ordering operator '<' for type 'unknown' > Use an explicit ordering operator or modify the query > > If I remove the DISTINCT keyword it works: > select tnr, titel, 'TEST' AS testcol from tTitel; > > Greetings, > Andreas > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
В списке pgsql-sql по дате отправления: