Re: BUG #3263: SQL Command error between versions

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Nilay Ceter <nilayceter(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3263: SQL Command error between versions
Date: 2007-05-08 18:47:52
Message-ID: 4640C5D8.5090002@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2007-05-08 19:59:30 Re: PSQL support on HP-UX, Solaris and AIX
Previous Message Sridhar Sourirajan 2007-05-08 18:26:30 PSQL support on HP-UX, Solaris and AIX