Marcin Krol <mrkafk@xxxxxxxxx> writes: > When I issue: > SELECT * FROM virtualization; > I get all the fields: > reservations=# SELECT * FROM virtualization; > id | Virtualization | color > ----+-----------------+--------- > But when I try to order by column Virtualization: > reservations=# SELECT * FROM virtualization ORDER BY Virtualization; You need SELECT * FROM virtualization ORDER BY "Virtualization"; What you typed is a request to sort by the composite row value, which isn't supported in any pre-8.4 release. You might care to go re-read the manual about identifier quoting and case folding. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
