Problem with planer

From: <Eugen(dot)Konkov(at)aldec(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Problem with planer
Date: 2008-08-26 08:13:25
Message-ID: 000601c90753$9e916ae0$1200a8c0@kharkov.localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas H. 2008-08-26 09:45:09 Re: BUG #4281: some types of errors do not log statements
Previous Message Zahid Khan 2008-08-26 08:11:59 Behavior change in PG8.3?