Re: SQL and parse errors

remove the as in "date_larger(m.effdt, q.effdt) as
effdt)::float8" on the line you marked

Jim

> 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