Re: Patch to add CREATE OPERATOR CLASS

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Patch to add CREATE OPERATOR CLASS
Дата
Msg-id Pine.LNX.4.30.0202262002040.685-100000@peter.localdomain
обсуждение исходный текст
Ответ на Patch to add CREATE OPERATOR CLASS  (Bill Studenmund <wrstuden@netbsd.org>)
Ответы Re: Patch to add CREATE OPERATOR CLASS  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@gmx.net


В списке pgsql-patches по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: ALTER TABLE OWNER: change indexes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Patch to add CREATE OPERATOR CLASS