Re: Problem with planer

> can you share the PostgreSQL version you are using
PG8.3.1
>maybe you are facing some sort of corruption?
I do not know. All other works fine except that.

----- Original Message -----
From: "Hans-Juergen Schoenig" <postgres(at)cybertec(dot)at>
To: <Eugen(dot)Konkov(at)aldec(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Sent: Tuesday, August 26, 2008 1:15 PM
Subject: Re: [BUGS] Problem with planer

> Eugen(dot)Konkov(at)aldec(dot)com wrote:
>> select ats.id, ap.value from akh_test_suit ats
>> LEFT JOIN akh_properties ap on ap.ID = ats.test_suit_type_id
>> where ats.ID = 472
>> id | value
>> 472 | 472
>> ID -- integer
>> value -- text
>> select * from akh_test_suit ats
>> LEFT JOIN akh_properties ap on ap.ID = ats.test_suit_type_id
>> where ats.ID = 472 and ap.value::integer = ats.ID
>> ERROR: invalid input syntax for integer: "--username sergeiz --password
>> sergeiz --non-interactive svn://sergeiz"
>> akh_properties.values has non numeric values, but those rows do not (MUST
>> NOT) participate in results as showed in first query
>> Why PG check them?
>
> can you share the PostgreSQL version you are using with us?
> maybe you can compile a test case?
> or maybe you are facing some sort of corruption? what happens after dump /
> reload?
>
> many thanks,
>
> hans
>
> --
> Cybertec Schönig & Schönig GmbH
> PostgreSQL Solutions and Support
> Gröhrmühlgasse 26, A-2700 Wiener Neustadt
> Tel: +43/1/205 10 35 / 340
> www.postgresql-support.de, www.postgresql-support.com
>