lto:[EMAIL PROTECTED]
Sent: Wednesday, November 30, 2005 4:28 PM
To: James M Doherty
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Quote_literal()
"James M Doherty" <[EMAIL PROTECTED]> writes:
> declare
> SQL text;
> NSQLtext;
> SQL := '
"James M Doherty" <[EMAIL PROTECTED]> writes:
> declare
> SQL text;
> NSQLtext;
> SQL := ''10/3/2009'';
> NSQL := quote_literal(SQL);
> The result is '10/3/2009 with no closing quote.
Works for me:
regression=# create function foo() returns text as '
regression'# declar
self!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of James M Doherty
Sent: Wednesday, November 30, 2005 2:33 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] quote_literal() fails with unmatched quotes
I have had the following problem and been unable to
declare
SQL text;
NSQLtext;
SQL := ''10/3/2009'';
NSQL := quote_literal(SQL);
The result is '10/3/2009 with no closing quote.
Jim
James M Doherty
Principal
JMD CONSULTING
411 Thunderbay Dr
Georgetown, TX 78626
A reputation is something others give you HONOR is som
"James M Doherty" <[EMAIL PROTECTED]> writes:
> I have had the following problem and been unable to determine the cause !
Can you show us a complete example? I can't see what's going on from
the info you've provided ...
regards, tom lane
---(end o
I have had the following problem and been unable to determine the cause !
nmostlikemat := iso_date(nmostlikemat);
EXECUTE ''insert into scenario_inv (''
|| ''inv_id,''
|| ''record_date,''
|| ''scenario_type,''
|| ''mostlikemat,''
|| ''mktpr,''
|| ''mktyld )''
