| From: | John Fabiani <johnf(at)jfcomputer(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | using a generated series in function |
| Date: | 2011-12-16 04:16:27 |
| Message-ID: | 1356101.40bZh1B7cs@linux-12 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
I am attempting (without success) use the generated series of dates that come
from:
select (cast(date_trunc('week', '2011-11-20'::date ) as date) + (i+6)) as
week_date from generate_series(0,84,7) i
in a function.
select function_name(integer, date); -- function returns a numeric
This does NOT work:
select (function_name(303, week_date::date)) as week_date where week_date in
(select (cast(date_trunc('week', '2011-11-20'::date ) as date) + (i+6)) as
week_date from generate_series(0,84,7) i )
The error is:
ERROR: column "week_date" does not exist
LINE 1: select (xchromasun._chromasun_getqtyordered(303, week_date::...
I hope I can do this? What am I doing wrong?
Johnf
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Johnston | 2011-12-16 04:56:05 | Re: using a generated series in function |
| Previous Message | Craig Ringer | 2011-12-16 03:57:14 | Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this? |