From: | Timothy Madden <terminatorul(at)gmail(dot)com> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | Adrian Klaver <aklaver(at)comcast(dot)net>, pgsql-general(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: Can the string literal syntax for function definitions please be dropped ? |
Date: | 2009-10-25 22:06:38 |
Message-ID: | 5078d8af0910251506ue3f9d33t3593f8f2f36ad5a1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, Oct 25, 2009 at 11:33 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:
> On Sun, Oct 25, 2009 at 2:43 PM, Timothy Madden <terminatorul(at)gmail(dot)com>
> wrote:
> > Just like when I write C++ applications I use standards-conforming C++,
> when
> > I write SQL
> > applications I would like to use standard-conforming SQL.
>
> But as soon as the rubber hits the road, not two C or C++ compilers
> are really 100% compatible as are no two SQL implementations.
>
> > For SQL, at the current conformance and compatibility level among DBMS
> > providers in use
> > today, one could rightly say there is no such thing as conforming or
> > portable SQL application
> > in real-world.
>
> A large part of the reason for this is that parts of the SQL spec are
> just plain strange and weird and implementing them gains us little or
> nothing. The SQL spec is far more open to interpretation than the C
> or C++ specs, and has changed a LOT more in the last ten years than
> those as well. It's a moving target in many ways, and while many
> parts of it make perfect sense to be implemented as written, a
> noticeable minority of it doesn't warrant implementation / changes to
> comply.
>
>
I am only talking about conforming syntax for features PostgreSql already
has.
That could gain something, right ?
And there are C/C++ applications that compile on many systems, like
Postgres is, despite the fact that no two C++ compilers are 100% compatible.
Thank you,
Timothy Madden
From | Date | Subject | |
---|---|---|---|
Next Message | Timothy Madden | 2009-10-25 22:12:35 | Re: Can the string literal syntax for function definitions please be dropped ? |
Previous Message | Tom Lane | 2009-10-25 22:01:18 | Re: Can the string literal syntax for function definitions please be dropped ? |