From: Byron Nikolaidis <byronn@insightdist.com>
To: Billy G. Allie <Bill.Allie@mug.org>
Cc: pgsql-interfaces@postgreSQL.org
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: [HACKERS] Re: [INTERFACES] Odbc parser error
Date: Fri, 18 Sep 1998 09:23:26 -0400
Message-ID: <36025ECD.1DC5CE75@insightdist.com> (raw)
References: <199809172337.TAA25897@bgalli.mug.org>
Billy G. Allie wrote:
> How about subsitution any occurance of /=[ \t]*?/ with "IS NULL". This should
> work for both select and update statements.
> --
Yes, sure, it could be done, assuming I could get a regex library for VC++. But I
think it would be more of a kludge than a solution. Even the current substitution
of the ? with the parameter data is a kludge. The frontend shouldn't be rewriting
the sql string to stick parameters in.
The real point of the whole thing is that if the backend recognized parameters and
there was a protocol for passing the data over, we would be able to do some cool
things we have never been able to do. Not just passing NULL, but also passing
larger parameter data without worrying about running into the upper limit of the
statement string. It would also be easier to send binary data. And, assuming the
protocol allowed it, you could retrieve information from the backend about a
particular parameter, such as its precision, data type, nullablity, etc.
And its not just ODBC that would benefit. JDBC has the same semantics. And I
believe Embedded SQL does too.
Byron
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: byronn@insightdist.com, Bill.Allie@mug.org, pgsql-hackers@postgreSQL.org
Subject: Re: [HACKERS] Re: [INTERFACES] Odbc parser error
In-Reply-To: <36025ECD.1DC5CE75@insightdist.com>
* 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