From: Sferacarta Software <sferac@bo.nettuno.it>
To: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
To: Byron Nikolaidis <byronn@insightdist.com>
To: pgsql-hackers@postgresql.org
Subject: Re[2]: [HACKERS] Re: [INTERFACES] Odbc parser error
Date: Tue, 27 Oct 1998 16:01:11 +0100
Message-ID: <17667.981027@bo.nettuno.it> (raw)
References: <3634B139.FF7CAF7D@alumni.caltech.edu>
Hello Thomas,
lunedì, 26 ottobre 98, you wrote:
>> JS> Yes, I would to suggest a way to solve this problem because in
>> JS> Access we can't link two tables by a numeric field
>> JS> # conn=75511800, query='SELECT "order_detail"."numero" FROM
>> JS> "order_detail" WHERE ("numero" = NULL )'
>> JS> I know this is not standard but Access understand both syntaxes
>> JS> SELECT * FROM table WHERE field IS NULL;
>> JS> SELECT * FROM table WHERE field = NULL;
>> JS> Why not to get PostgreSQL to understand it also ?
>> Done. I modify the pgsql/src/backend/gram.y
>> How about to add it to official release ?
TGL> Or, how about insisting that your commercial software suppliers conform
TGL> to one of the simplest and clearest part of the SQL standard they claim
TGL> to support? Instead of using those suppliers who insist on making small
TGL> and large incompatibilities in their popular software packages to ensure
TGL> that only their own products can interoperate with them?
You are right Tom, but you know there is no way to have something from
those bastards, I prefer to talk with a wall.
TGL> *slap* Ow! Ok, Ok!
TGL> It looks like a nice patch. But it is too late to get it into v6.4. It
TGL> looks like a good addition to v6.5...
TGL> *slap* OW! OK!
TGL> In fact, it is such a nice feature that I'm sure it will fit nicely into
TGL> v6.4.1, and you are welcome to submit a patchset to post on
TGL> postgresql.org to fix v6.4.
TGL> *grin*
TGL> It would be best to include patches for both gram.y and a full gram.c so
TGL> that users may not have to rebuild the parser. Also, if we run into
TGL> parser syntax conflicts in the future it would be a candidate for
TGL> removal, I suppose.
Should I send the patch now or after v6.4 is released ?
Jose'
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: sferac@bo.nettuno.it, lockhart@alumni.caltech.edu, byronn@insightdist.com, pgsql-hackers@postgresql.org
Subject: Re: Re[2]: [HACKERS] Re: [INTERFACES] Odbc parser error
In-Reply-To: <17667.981027@bo.nettuno.it>
* 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