Re: Ordering a record returned from a stored procedure - date

Kent Anderson wrote:
> Never mind, it requires '''''''' on each side of the variable.

You will be delighted to learn that "dollar quoting" is in 8.0, which 
allows you to do things like:

CREATE FUNCTION .... AS $$   ...function body here without needing doubling of '
$$
LANGUAGE plpgsql;

I believe you can nest them too so long as you change the included 
string: $UNIQUESYMBOL1$

> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Kent Anderson
> Sent: Monday, October 18, 2004 1:32 PM
> To: Pgsql-Sql@Postgresql. Org
> Subject: Re: [SQL] Ordering a record returned from a stored procedure -
> date issue
> 
> 
> I have the code working except for the date part of the where clause. Can
> anyone point out how
> yield_date = ''''10/18/2004''''
> 
> can be translated so the 10/18/2004 is coming from a variable?
> ie yield_date = '' ... variable with date

--   Richard Huxton  Archonet Ltd