How to deal with order by, group by, distinct for user-defined types

Поиск
Список
Период
Сортировка
От Ruey-Lung Hsiao
Тема How to deal with order by, group by, distinct for user-defined types
Дата
Msg-id I9Wmd.45796$QJ3.27129@newssvr21.news.prodigy.com
обсуждение исходный текст
Ответы Re: How to deal with order by, group by, distinct for user-defined types  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,
  I implemented a user-defined type, say X, and when I want to do the 
following queries, Postgresql will complain

CREATE TABLE Table1 ( id integer, object X );

SELECT X, count(*) from Table1
GROUP BY X;

> ERROR:  could not identify an ordering operator for type X
> HINT:  Use an explicit ordering operator or modify the query.
  My question is: how do I find or define ordering operators for my 
user-defined type?

Thanks.

Ruey-Lung Hsiao


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Harry Smith"
Дата:
Сообщение: Usenet Discussion Proposal
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to deal with order by, group by, distinct for user-defined types