Re: Help on a complex query (avg data for day of the week) - Mailing list pgsql-sql

Michael,

Thanks heaps for that!

Cheers,

Matt Smith

On Thu, 22 Dec 2005 01:37 pm, Michael Fuhr wrote:
> On Thu, Dec 22, 2005 at 11:59:24AM +1100, Matthew Smith wrote:
> > Sadly I am using 7.3, it seems that generate_series() is 8.0 and later.
>
> Yes, but it's easily written in PL/pgSQL for earlier versions.
> Example:
>
> CREATE FUNCTION generate_series(integer, integer)
> RETURNS SETOF integer AS '
> DECLARE
>     i  integer;
> BEGIN
>     FOR i IN $1 .. $2 LOOP
>         RETURN NEXT i;
>     END LOOP;
>     RETURN;
> END;
> ' LANGUAGE plpgsql VOLATILE STRICT;