using a generated series in function

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-sql by date

  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?