Re: SQL and parse errors

--That's what it was: I took out the 'as name_of_whatever'
in the expression.

--Thanks Stephan / Jim B.

-X

-----Original Message-----
From: Stephan Szabo [mailto:sszabo(at)megazone23(dot)bigpanda(dot)com]
Sent: Tuesday, March 05, 2002 11:15 AM
To: Johnson, Shaunn
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] SQL and parse errors

On Tue, 5 Mar 2002, Johnson, Shaunn wrote:

> 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 <<<--

^^ - I don't think you can use as clauses inside the expression... take
out the extra as enddt and as effdt?