[EMAIL PROTECTED] 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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
