Jeff Davis <pg...@j-davis.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
