Re: [INTERFACES] Re: [HACKERS] changes in 6.4

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [INTERFACES] Re: [HACKERS] changes in 6.4
Дата
Msg-id 199807161837.OAA05257@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [INTERFACES] Re: [HACKERS] changes in 6.4  (dg@illustra.com (David Gould))
Список pgsql-interfaces
> > > > hannu-> check (trim(a) <> '' or trim(b) <> ''));
> > > > ERROR:  parser: parse error at or near "trim"
> > >
> > > TRIM is keyword, not a function...
> > > We have to copy some lines in gram.y
>
> I think that having trim as a keyword is a problem. The primary virtue of
> postgres is that everything is either a function or a type and as such is
> definable by the user and resolved at runtime. Making a keyword out of a
> function spoils that capability.

Problem was that SQL standard syntax (or Oracle) did not allow it to be
a function.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

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

Предыдущее
От: dg@illustra.com (David Gould)
Дата:
Сообщение: Re: [INTERFACES] Re: [HACKERS] changes in 6.4
Следующее
От: Peter T Mount
Дата:
Сообщение: Re: [DOCS] Re: [INTERFACES] libpq & user