BUG #3263: SQL Command error between versions
От | Nilay Ceter |
---|---|
Тема | BUG #3263: SQL Command error between versions |
Дата | |
Msg-id | 200705081808.l48I81Xl095472@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #3263: SQL Command error between versions
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 3263 Logged by: Nilay Ceter Email address: nilayceter@gmail.com PostgreSQL version: 8.2 Operating system: Windows XP Description: SQL Command error between versions Details: We are developing a network based application, using postgre sql. Earlier version has been developed using Postgre SQL 8.0 and there was no problem. But we use Postgre SQL 8.2 in new version and we are experiencing some problems about our sql commands. The command line: select seri_no, ad as baslik, kull_ref as Kullanıcı_Referansi, sorumlu from onay,dokuman where p_id='yonetici' and onay.dokuman_id=dokuman.seri_no and onay_durum.seri_no=seri_no and onay_durum.p_id='yonetici' and (dokuman.durum=1 or dokuman.durum=2 or dokuman.durum=6 or dokuman.durum=7) and onay_durum.durum=0 and seri_no>0 was working properly in Postgre SQL 8.0 but in version Postgre SQL 8.2 the second "and" gives an error. would you please help us? Best Regards
В списке pgsql-bugs по дате отправления: