From: John Fabiani <johnf@jfcomputer.com>
To: pgsql-sql@postgresql.org
Subject: using a generated series in function
Date: Thu, 15 Dec 2011 20:16:27 -0800
Message-ID: <1356101.40bZh1B7cs@linux-12>
User-Agent: KMail/4.7.2 (Linux/3.1.0-1.2-desktop; KDE/4.7.2; x86_64; ; )
MIME-Version: 1.0
Content-Transfer-Encoding: 7Bit
Content-Type: text/plain; charset="us-ascii"

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