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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kent Anderson Sent: Monday, October 18, 2004 1:32 PM To: [EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
