Re: Range Types
Jeff Davis <pgsql@j-davis.com>
From: Jeff Davis <pgsql@j-davis.com>
To: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Cc: pgsql-hackers@postgresql.org
Date: 2011-02-08T17:10:33Z
Lists: pgsql-hackers
On Mon, 2011-02-07 at 18:23 +0100, Dimitri Fontaine wrote: > 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. There are other options, like "CANONICAL", so where do those fit? If CREATE TYPE already has an options list, it seems a little strange to add grammar to support this feature. "USING" doesn't seem to mean a lot, except that we happen to use it in other contexts to mean "operator class". Regards, Jeff Davis