From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | SQL and parse errors |
Date: | 2002-03-05 14:57:35 |
Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB0452E049@snt452.corp.bcbsm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Howdy:
Running Postgres 7.1.3 on RedHat Linux 7.2, kernel 2.4.7-rel 10.
Have an SQL question, which may very well be that
I need a second pair of eyes to trouble shoot the script.
[script]
explain
select
q.qid,
q.year,
m.contract,
m.mbr_num,
m.bu,
m.mbr_sex,
m.product,
m.prov_num,
m.riskgrp,
p.c_spec_1 as spec,
date_larger(m.effdt, q.effdt) as effdt,
date_smaller(m.enddt, q.enddt) as enddt,
-->>> (date_smaller(m.enddt, q.enddt) as enddt -
date_larger(m.effdt, q.effdt) as effdt)::float8 / 30.4 as memmonth <<<--
from members m,
product p,
quarters q
where
m.prov_num=p.c_prov_num
--------- make sure *all* the spans overlap one another ----
and not (
m.enddt < q.effdt
or m.effdt > q.enddt
)
;
[/script]
I believe the problem comes from what's marked off by
the arrows. The error I get from this is:
ERROR: parser: parse error at or near "as"
If I comment that out, things work. It *used* to work
before, but for the life of me, I don't recall changing
anything ...
Where is the syntax error?
Thanks!
-X
From | Date | Subject | |
---|---|---|---|
Next Message | Fran Fabrizio | 2002-03-05 15:04:13 | Re: storing intermediate results in recursive plpgsql functions |
Previous Message | Bill McGonigle | 2002-03-05 14:25:11 | Re: pg_dumpall storing multiple copies of DB's? |