From: | Hans-Juergen Schoenig <postgres(at)cybertec(dot)at> |
---|---|
To: | Eugen(dot)Konkov(at)aldec(dot)com |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Problem with planer |
Date: | 2008-08-26 10:15:50 |
Message-ID: | 48B3D7D6.3050709@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Eugen.Konkov | 2008-08-26 12:36:15 | Re: Problem with planer |
Previous Message | Thomas H. | 2008-08-26 09:45:09 | Re: BUG #4281: some types of errors do not log statements |