Re: Range Types

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Range Types
Date: 2011-02-08 17:10:33
Message-ID: 1297185033.27157.181.camel@jdavis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2011-02-08 17:14:23 Re: Named restore points
Previous Message Tom Lane 2011-02-08 17:10:24 Re: Extensions support for pg_dump, patch v27