pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: dg@illustra.com
Cc: hannu@trust.ee
Cc: vadim@krs.ru
Cc: pgsql-interfaces@postgreSQL.org
Cc: hackers@postgreSQL.org
Subject: Re: [INTERFACES] Re: [HACKERS] changes in 6.4
Date: Thu, 16 Jul 1998 14:37:17 -0400 (EDT)
Message-ID: <199807161837.OAA05257@candle.pha.pa.us> (raw)
In-Reply-To: <9807161829.AA16975@hawk.illustra.com>

> > > > 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)



view thread (29+ messages)  latest in thread

Message-ID: <199807161837.OAA05257@candle.pha.pa.us>
Permalink:  ../199807161837.OAA05257@candle.pha.pa.us/
Also on:    postgresql.org/message-id/199807161837.OAA05257@candle.pha.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: maillist@candle.pha.pa.us, dg@illustra.com, hannu@trust.ee, vadim@krs.ru, hackers@postgreSQL.org
  Subject: Re: [INTERFACES] Re: [HACKERS] changes in 6.4
  In-Reply-To: <199807161837.OAA05257@candle.pha.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox