Quote_literal()

From: "James M Doherty" <jim(at)jdoherty(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Quote_literal()
Date: 2005-11-30 21:20:36
Message-ID: !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAGKgFc6RcN0+tZU9CuUmdQ8KAAAAQAAAAA/QrXVG4jUi12IN6YW28cAEAAAAA@jdoherty.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

declare
SQL text;
NSQL text;

SQL := ''10/3/2009'';

NSQL := quote_literal(SQL);

The result is '10/3/2009 with no closing quote.

Jim

James M Doherty
Principal
<file://C:\Documents and Settings\jmd\Application
Data\Microsoft\Signatures\odoherty_crest.jpg>
JMD CONSULTING
411 Thunderbay Dr
Georgetown, TX 78626
A reputation is something others give you HONOR is something you give
yourself!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message James M Doherty 2005-11-30 21:22:25 Re: quote_literal() fails with unmatched quotes
Previous Message Tom Lane 2005-11-30 21:04:20 Re: quote_literal() fails with unmatched quotes