Re: Patch to add CREATE OPERATOR CLASS

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bill Studenmund <wrstuden(at)netbsd(dot)org>
Cc: <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Patch to add CREATE OPERATOR CLASS
Date: 2002-02-27 01:16:10
Message-ID: Pine.LNX.4.30.0202262002040.685-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-patches

Bill Studenmund writes:

> I've attached a patch to add the CREATE OPERATOR CLASS we talked about on
> -hackers.

I'm having a few issues with the syntax. Basically, what you have is

CREATE OPERATOR CLASS name FOR TYPE type AS ... USING ... WITH ... AND ...

How about choosing these key words so that they actually declare what the
... stands for. It would also nice if these could be allowed in a more
flexible order.

For instance,

CREATE OPERATOR CLASS name FOR TYPE type
{ STORAGE name
| ACCESS METHOD name
| FUNCTION num name(x, y, z)
| OPERATOR num name
} [, ...]

or

CREATE OPERATOR CLASS name FOR TYPE type
{
STORAGE name
| ACCESS METHOD name } [, ...]
| FUNCTION (
num name(x, y, z),
...
)
| OPERATOR (
num name,
...
)
}

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Hannu Krosing 2002-02-27 04:16:06 Re: [HACKERS] WAL Performance Improvements
Previous Message Bruce Momjian 2002-02-26 22:32:23 Re: ALTER TABLE OWNER: change indexes