From: | Matthew Bellew <matthew(at)bellew(dot)net> |
---|---|
To: | Kris Jurka <books(at)ejurka(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Inconsistent casting with literal vs parameter |
Date: | 2006-02-08 00:16:39 |
Message-ID: | 43E93867.2050805@bellew.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Right, I missed that.
My last 2 cents on the whole topic. There is a fundamental design issue
here with deciding to handle the expression /column <
(value/literal/parameter typed or not)/ by converting the column to a
string. Obviously, with INSERT INTO the data values must be coerced to
the destination column type. In this case, while there is a
parsing/optimizing decision to be made, it should be made with a strong
bias to convert to the column type (and then handling any tricky
coercion failures or optimization issues).
Again thanks for your help,
Matt
Kris Jurka wrote:
>
>
> On Tue, 7 Feb 2006, Matthew Bellew wrote:
>
>> JDBC Driver Version: PostgreSQL 8.1 JDBC3 with SSL (build 404)
>>
>> So, does this mean this parameter is not properly respected in the
>> driver?
>>
>
> Yes, this parameter is only available in the 8.2 driver.
>
> Kris Jurka
>
From | Date | Subject | |
---|---|---|---|
Next Message | Nelson Arape | 2006-02-08 01:16:47 | Re: Statement has been closed (only in Windows) |
Previous Message | Kris Jurka | 2006-02-08 00:02:46 | Re: Inconsistent casting with literal vs parameter |