[SQL] using a generated series in function

2011-12-15 Thread John Fabiani
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 do

Re: [SQL] using a generated series in function

2011-12-15 Thread David Johnston
On Dec 15, 2011, at 23:16, John Fabiani wrote: > 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 fu