Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> Ok, but what should the parameter to CREATE TYPE ... AS RANGE be then?
>
> CREATE TYPE foo AS RANGE (
> SUBTYPE = ...
> SUBTYPE_BTREE_OPERATOR_CLASS = ...
> );
>
> is a little verbose. Ideas?
I would think
CREATE TYPE foo AS RANGE (bar) USING (btree_ops);
The USING clause is optional, because you generally have a default btree
opclass for the datatype.
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support