Hi, Le mardi 31 mars 2009 à 17:35:58, Marcin Krol a écrit : > [...] > I'm having this completely weird problem that ORDER BY doesn't seem to > work correctly in PG 8.1 as bundled in RedHat 5. > > When I issue: > > SELECT * FROM virtualization; > > I get all the fields: > > reservations=# SELECT * FROM virtualization; > id | Virtualization | color > ----+-----------------+--------- > 1 | BOX | #FAFAFA > 2 | LPAR | #999999 > 3 | BOX ZONE HOST | #FAFAFA > 4 | NPAR | #9966CC > 5 | VPAR | #9966CC > > But when I try to order by column Virtualization: > > reservations=# SELECT * FROM virtualization ORDER BY Virtualization; > > ERROR: could not identify an ordering operator for type virtualization > HINT: Use an explicit ordering operator or modify the query. >
You should put double quotes for the column name because of the uppercase V in its name. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
