Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group