Обсуждение: BUG #3263: SQL Command error between versions

Поиск
Список
Период
Сортировка

BUG #3263: SQL Command error between versions

От
"Nilay Ceter"
Дата:
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

Re: BUG #3263: SQL Command error between versions

От
Heikki Linnakangas
Дата:
Nilay Ceter wrote:
> 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.

What's the error message?

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com