From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Kent Anderson <kenta(at)ezyield(dot)com> |
Cc: | "Pgsql-Sql(at)Postgresql(dot) Org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Ordering a record returned from a stored procedure - date |
Date: | 2004-10-19 08:21:32 |
Message-ID: | 4174CE8C.6090707@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)postgresql(dot)org
> [mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Kent Anderson
> Sent: Monday, October 18, 2004 1:32 PM
> To: Pgsql-Sql(at)Postgresql(dot) 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
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Gibson | 2004-10-19 11:47:26 | Re: problems using phpPgAmin |
Previous Message | Karsten Hilbert | 2004-10-19 07:17:23 | Re: bibliographic schema |