Обсуждение: operator class for user defined type

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

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

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