Quote_literal() - Mailing list 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!