| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SQL and parse errors |
| Date: | 2002-03-05 16:14:43 |
| Message-ID: | 20020305081358.N90982-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johnson, Shaunn | 2002-03-05 16:24:59 | Re: SQL and parse errors |
| Previous Message | tony | 2002-03-05 16:13:56 | Re: database problem.. |