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 по дате отправления: