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

Re: pgsql/ oc/src/sgml/installation.sgml oc/src/sg ...

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: lockhart(at)fourpalms(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql/ oc/src/sgml/installation.sgml oc/src/sg ...
Date: 2001-10-12 17:50:34
Message-ID: 200110121750.f9CHoYL10316@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-committers
> > >>> Allow optional () after current_user, session_user, user, current_time,
> > >>> current_timestamp, current_date for ODBC compatibility.
> > >> It's not apparent to me that this is an improvement in our standards
> > >> compatibility.
> > > ODBC is generally thought of as being a standard.
> > True ... if it's okay with Thomas then I won't object.
> 
> ODBC is a standard, but not the standard targeted by our implementation
> of SQL in the backend, and does not *require* direct support for all
> features in the backend. In some cases, we solve that in the ODBC
> driver, with perhaps help from extensions defined in odbc.sql.
> 
> SQL99 indicates that an argument between parens is required, so this
> would be an extension to that standard. Also, if we agree that this
> extension must be in the backend because the ODBC driver cannot
> implement it (I'm not certain about that; it looks pretty reasonable to
> fit it in with a few changes to the mapFunction() routine) then I'd like
> to see it implemented as part of the original CURRENT_TIME(arg)
> definition, not as a completely separate rule (or did you get
> shift/reduce conflicts trying it that way?).

That is a good argument.  Seems isolating it in the ODBC code would be
optimal.  Does that mean that SQL99 doesn't like now() and functions
with no arguments?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-committers by date

Next:From: Tom LaneDate: 2001-10-12 17:54:44
Subject: Re: pgsql/ oc/src/sgml/installation.sgml oc/src/sg ...
Previous:From: momjianDate: 2001-10-12 17:46:02
Subject: pgsql/. HISTORY

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