From: | "Guido Barosio" <gbarosio(at)gmail(dot)com> |
---|---|
To: | "venu gopal" <gopalonline2(at)yahoo(dot)co(dot)uk> |
Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: what the problem with this query |
Date: | 2006-04-14 11:31:36 |
Message-ID: | f7f6b4c70604140431j4dbb7f3dx348ec60c286814e5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
o.orgunitid = e.orgunitid)
That ")" is not valid Venu. (Nothing is being enclosed)
Regards,
Guido
On 4/14/06, venu gopal <gopalonline2(at)yahoo(dot)co(dot)uk> wrote:
>
> Hi all,
> When i try to run the following query it gives the following error what
> 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 = o.orgunitname) INNER JOIN (SELECT
> orgunitid, entrynumber FROM routinedataou4 WHERE dataelementid=1195 AND
> dataperiodid = 86) AS e ON o.orgunitid = e.orgunitid) AS new_table USING
> UNIQUE ogc_fid USING SRID=-1
>
> Error::ERROR: syntax error at or near ")" at character 333
>
> Regards,
> venu
>
>
--
Guido Barosio
-----------------------
http://www.globant.com
guido(dot)barosio(at)globant(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2006-04-14 11:36:05 | Re: what the problem with this query |
Previous Message | Achilleus Mantzios | 2006-04-14 11:27:41 | Re: Kernel 2.4->2.6 upgrade results in PANIC: could not locate a |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2006-04-14 11:36:05 | Re: what the problem with this query |
Previous Message | Achilleus Mantzios | 2006-04-14 11:27:41 | Re: Kernel 2.4->2.6 upgrade results in PANIC: could not locate a |