Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #3263: SQL Command error between versions - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: BUG #3263: SQL Command error between versions
Date
Msg-id 4640C5D8.5090002@enterprisedb.com
Whole thread Raw
In response to BUG #3263: SQL Command error between versions  ("Nilay Ceter" <nilayceter@gmail.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: "Nilay Ceter"
Date:
Subject: BUG #3263: SQL Command error between versions
Next
From: "Sridhar Sourirajan"
Date:
Subject: PSQL support on HP-UX, Solaris and AIX