Hi

I have created my own user defined type, and an operator class for this type.
Then i can use the order by clause with this type, but it is sorting with the
lowest value on top. Is it possible to get it to sort with the highest value
on top?

thanks

-Kjetil

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Kjetil Haaland <kjetil.haaland@student.uib.no> writes:
> I have created my own user defined type, and an operator class for this type.
> Then i can use the order by clause with this type, but it is sorting with the
> lowest value on top. Is it possible to get it to sort with the highest value
> on top?

ORDER BY foo DESC

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Kjetil Haaland wrote:
> Hi
>
> I have created my own user defined type, and an operator class for
> this type.
> Then i can use the order by clause with this type, but it is sorting
> with the lowest value on top. Is it possible to get it to sort with
> the highest value on top?
>


Does order by xxx DESC help?



--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings