[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] What this parser mean?
From:       Guy Fraser <guy () incentre ! net>
Date:       2003-03-24 15:56:15
[Download RAW message or body]

Hi

FYI

This line will not work in PostgreSQL 7.3 :

+ " limit " + recordPerpage + "," + beginRecord;

Change it to :

+ " limit " + recordPerpage + " offset " + beginRecord;

This works in pre PostgreSQL 7.3 versions as well.


Guy

Abdul Wahab Dahalan wrote:

> I wrote a java program to query a data from 4 tables and the string
> query is like:
> 
> querydata ="select
> bizfavorite.bizid,bizprofile.bizname,bizprofile.bizphone,bizprofile.bizfax,bizfavorite.searchtype,"
>  
> + "bizfavorite.keyword,to_char(bizfavorite.listdate,'DD-MM-YYYY') as
> listdate,bizfavorite.offerid,offer.otype,offer.bizid as obizid,"
> + "to_char(offer.oposted_date,'DD-MM-YYYY') as
> oposted_date,to_char(offer.oexpiry_date,'DD-MM-YYYY') as oexpiry_date,"
> + "userprofile.username,userprofile.ufullname,userprofile.uemail"
> + " from bizfavorite join bizprofile using(bizid) join userprofile
> using(bizid) left join offer using(offerid)"
> + " where bizfavorite.username= ? and urole='1' order by listdate desc"
> 
> + " limit " + recordPerpage + "," + beginRecord;
> 
> When I run this query, I got this message : Message: ERROR:  parser:
> parse error at or near "-"
> 
> but when I ran this query from psql command prompt its ok.I got what I
> want.
> b2bscm=> select
> bizprofile.bizname,bizprofile.bizphone,bizprofile.bizfax,bizfavorite.searchtype,bizfavorite.keyword,to_char(bizfavorite.listdate,'DD-MM-YYYY')
>  as listdate,bizfavorite.offerid,offer.otype,offer.bizid as
> obizid,to_char(offer.oposted_date,'DD-MM-YYYY') as
> date,to_char(offer.oexpiry_date,'DD-MM-YYYY') as
> oexpiry_date,userprofile.username,userprofile.ufullname,userprofile.uemail
> from bizfavorite join bizprofile using(bizid) join userprofile
> using(bizid) left join offer using(offerid) where bizfavorite.username=
> 'faiz' and urole='1' order by listdate desc limit 8,0;
> 
> Any help, very much appreciated..Thanks
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 
> 
> 
> 


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


[prev in list] [next in list] [prev in thread] [next in thread]