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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-committers by date

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