Marcin Krol <mrk...@gmail.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
