Problem with planer

Поиск
Список
Период
Сортировка
От
Тема Problem with planer
Дата
Msg-id 000601c90753$9e916ae0$1200a8c0@kharkov.localhost
обсуждение исходный текст
Ответы Re: Problem with planer
Re: Problem with planer
Список pgsql-bugs
select ats.id, ap.value from akh_test_suit ats
LEFT JOIN akh_properties ap on ap.ID =3D ats.test_suit_type_id
where ats.ID =3D 472

id | value
472 | 472
ID -- integer
value -- text


select * from akh_test_suit ats
LEFT JOIN akh_properties ap on ap.ID =3D ats.test_suit_type_id
where ats.ID =3D 472 and ap.value::integer =3D ats.ID

ERROR:  invalid input syntax for integer: "--username sergeiz --password se=
rgeiz --non-interactive svn://sergeiz"

akh_properties.values has non numeric values, but those rows do not (MUST N=
OT) participate in results as showed in first query
Why PG check them?

В списке pgsql-bugs по дате отправления: