From: Richard Huxton <dev@archonet.com>
To: Kent Anderson <kenta@ezyield.com>
Cc: Pgsql-Sql@Postgresql. Org <pgsql-sql@postgresql.org>
Subject: Re: Ordering a record returned from a stored procedure - date
Date: Tue, 19 Oct 2004 09:21:32 +0100
Message-ID: <4174CE8C.6090707@archonet.com> (raw)
In-Reply-To: <LPENJIOOLAIJBFKIBDKOIEAAFMAD.kenta@ezyield.com>
References: <LPENJIOOLAIJBFKIBDKOIEAAFMAD.kenta@ezyield.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, kenta@ezyield.com
Subject: Re: Ordering a record returned from a stored procedure - date
In-Reply-To: <4174CE8C.6090707@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox