DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:References:Mime-Version:In-Reply-To:X-Apple-Yahoo-Original-Message-Folder:Content-Type:Content-Transfer-Encoding:Message-Id:Cc:X-Mailer:From:X-Apple-Yahoo-Replied-Msgid:Subject:Date:To;
	b=0pB9SuA+QaR3mXhWYUPav5ljk0NeUqa3X20//vMkCCxLN2gl5pWwswcv/t2S0Pik8o2rPVXABvQ2JL9g90zcrlwT8x/3bo/pQSh3Kgvl/LjyNIJtysD5kYNDjeEu6pXQAHIddyxkmmQ0LIad2Z8nFgVrFp7xdhj05Z9ks3lGSDo=
	;
References: <1356101.40bZh1B7cs@linux-12>
Mime-Version: 1.0 (iPad Mail 8J2)
In-Reply-To: <1356101.40bZh1B7cs@linux-12>
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Message-Id: <B8982C63-B4D6-4088-BDA1-200D957B51B2@yahoo.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
From: David Johnston <polobo@yahoo.com>
Subject: Re: using a generated series in function
Date: Thu, 15 Dec 2011 23:56:05 -0500
To: John Fabiani <johnf@jfcomputer.com>

On Dec 15, 2011, at 23:16, John Fabiani <johnf@jfcomputer.com> wrote:

> Hi,
>=20
> I am attempting (without success) use the generated series of dates that c=
ome=20
> from:
> select (cast(date_trunc('week', '2011-11-20'::date ) as date) + (i+6)) as=20=

> week_date from generate_series(0,84,7) i=20
>=20
> in a function.
> select function_name(integer, date);  -- function returns a numeric
>=20
> This does NOT work:
> select (function_name(303, week_date::date)) as week_date where week_date i=
n=20
> (select (cast(date_trunc('week', '2011-11-20'::date ) as date) + (i+6)) as=
=20
> week_date from generate_series(0,84,7) i )
>=20
> The error is:
> ERROR:  column "week_date" does not exist
> LINE 1: select (xchromasun._chromasun_getqtyordered(303, week_date::...
>=20
> I hope I can do this?  What am I doing wrong?
> Johnf
>=20
>=20

"select ... as week_date where week_date in ..."

You are missing a FROM clause for the main select; the only FROM you have is=
 part of the IN target subquery.

David J.