Re: weird problem with PG 8.1

[Guillaume Lelarge <guillaume(at)lelarge(dot)info>]

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