X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id AB7CD11F709E for ; Fri, 14 Apr 2006 08:31:56 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 1.217 X-Spam-Level: * X-Spam-Status: No, score=1.217 required=5 tests=[BAYES_00=-2.599, SPF_HELO_SOFTFAIL=2.432, SPF_SOFTFAIL=1.384] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id VOooZniXqWx9 for ; Fri, 14 Apr 2006 08:31:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from pproxy.gmail.com (pproxy.gmail.com [64.233.166.179]) by postgresql.org (Postfix) with ESMTP id BAA9A11F6D64 for ; Fri, 14 Apr 2006 08:31:36 -0300 (ADT) Received: by pproxy.gmail.com with SMTP id x66so49983pye for ; Fri, 14 Apr 2006 04:31:36 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=r0g93My1NpaQfEVbInpZRpEfpo/8YZESNV+W94J3yK61Uj/T8TP5hCxbBnQoIm60vPA1q/vxqYpM9E21hOO+YAmaejHijD+GAtsVPodm0a00ijUROONCqpju9mc9yRJQYjPMJ6s6sZuTSEraOH894omoLbK37qudbV8wG07Q+0Y= Received: by 10.35.101.9 with SMTP id d9mr426249pym; Fri, 14 Apr 2006 04:31:36 -0700 (PDT) Received: by 10.35.103.9 with HTTP; Fri, 14 Apr 2006 04:31:36 -0700 (PDT) Message-ID: Date: Fri, 14 Apr 2006 12:31:36 +0100 From: "Guido Barosio" To: "venu gopal" Subject: Re: what the problem with this query Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org In-Reply-To: <20060414110916.9271.qmail@web25608.mail.ukl.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20060414110916.9271.qmail@web25608.mail.ukl.yahoo.com> X-Archive-Number: 200604/126 X-Sequence-Number: 21295 o.orgunitid =3D e.orgunitid) That ")" is not valid Venu. (Nothing is being enclosed) Regards, Guido On 4/14/06, venu gopal wrote: > > Hi all, > When i try to run the following query it gives the following error wha= t > was wrong in the query. > > Query:SELECT o.orgunitname AS ouname, e.entrynumber AS value_field, > centroid(c.the_geom) AS the_geom, c.ogc_fid AS ogc_fid FROM (ctrphc AS c > INNER JOIN orgunit o ON c.dhs_ouname =3D o.orgunitname) INNER JOIN (SELEC= T > orgunitid, entrynumber FROM routinedataou4 WHERE dataelementid=3D1195 AND > dataperiodid =3D 86) AS e ON o.orgunitid =3D e.orgunitid) AS new_table US= ING > UNIQUE ogc_fid USING SRID=3D-1 > > Error::ERROR: syntax error at or near ")" at character 333 > > Regards, > venu > > -- Guido Barosio ----------------------- http://www.globant.com guido.barosio@globant.com