The following code works in 8.4 but not 8.3.
Anyone know why, or what I need to do to change it?
SELECT aid, asid,
date_range (asdate, afdate)::date AS asdate,
In 8.4 it returns the expanded dataset as required. In 8.3 I get:
ERROR: set-valued function called in context that cannot accept a set
CONTEXT: PL/pgSQL function "date_range" line 4 at RETURN NEXT
Is there a way to use the integer only generate_series in 8.3 to generate
dates by typecasting to/from integers?
Group I.T. Manager
In response to
pgsql-sql by date
|Next:||From: Gary Stainburn||Date: 2012-01-19 16:10:15|
|Subject: Re: SOLVED - date range to set of dates expansion|
|Previous:||From: Gary Stainburn||Date: 2012-01-19 15:16:16|
|Subject: Re: date range to set of dates expansion|