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

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: dg(at)illustra(dot)com (David Gould)
Cc: hannu(at)trust(dot)ee, vadim(at)krs(dot)ru, pgsql-interfaces(at)postgreSQL(dot)org, hackers(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Re: [HACKERS] changes in 6.4
Date: 1998-07-16 18:37:17
Message-ID: 199807161837.OAA05257@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers 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(at)candle(dot)pha(dot)pa(dot)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)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gene Selkov, Jr. 1998-07-16 18:47:33 Re: [GENERAL] listing all tables
Previous Message David Gould 1998-07-16 18:29:26 Re: [INTERFACES] Re: [HACKERS] changes in 6.4

Browse pgsql-hackers by date

  From Date Subject
Next Message Summer 1998-07-16 21:15:21 Re: [GENERAL] COALESCE() or NVL()
Previous Message David Gould 1998-07-16 18:29:26 Re: [INTERFACES] Re: [HACKERS] changes in 6.4

Browse pgsql-interfaces by date

  From Date Subject
Next Message Stephen Lombardo 1998-07-16 23:41:27 Re: [INTERFACES] JDBC JAVA interface
Previous Message David Gould 1998-07-16 18:29:26 Re: [INTERFACES] Re: [HACKERS] changes in 6.4