Re: weird problem with PG 8.1

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