Re: [SQL] Potential bug in postgres 8.2.4

2007-05-24 Thread Tomas Doran
On 24 May 2007, at 15:51, Tom Lane wrote: Tomas Doran <[EMAIL PROTECTED]> writes: The tightening in general is biting me, but if the answer was 'it was deliberate tightening', and the behavior was consistent, then we'd have just dealt with it - it's the in-consist

Re: [SQL] Potential bug in postgres 8.2.4

2007-05-24 Thread Tomas Doran
On 24 May 2007, at 13:19, Richard Huxton wrote: Tomas Doran wrote: On 24 May 2007, at 12:34, Marcin Stępnicki wrote: I'm not sure if I understand you correctly, but it seems that you are comparing apples to oranges here (integer and character values). Yep, totally - it's not ni

Re: [SQL] Potential bug in postgres 8.2.4

2007-05-24 Thread Tomas Doran
On 24 May 2007, at 12:34, Marcin Stępnicki wrote: Dnia Thu, 24 May 2007 12:20:54 +0100, Tomas Doran napisał(a): CREATE TABLE testtable ( col1 char(1), data text ); INSERT INTO testtable (col1, data) VALUES ('1', 'foobar'); INSERT INTO testtable (co

[SQL] Potential bug in postgres 8.2.4

2007-05-24 Thread Tomas Doran
I'm not sure if this is a bug, or not - but it looks like one to me. if you say: CREATE TABLE testtable ( col1 char(1), data text ); INSERT INTO testtable (col1, data) VALUES ('1', 'foobar'); INSERT INTO testtable (col1, data) VALUES ('2', 'foobarbaz'); The following queries all wor