Re: weird problem with PG 8.1 - Mailing list pgsql-general

Marcin Krol <mrkafk@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