Re: problems with single quotes..

On Sun, Dec 02, 2001 at 10:00:22AM -0500, Tom Lane wrote:
> 
> You're not counting/escaping your quotes correctly.  That literal is
> unterminated:
> 
> '        opening quote
> ''        quoted quote (to put a quote in the string)
> \'        escaped quote (another way to do the same)
> ''        quoted quote
> oops        you're still inside the literal

Section 24.5.1.1. Quote Me on That: Escaping Single Quotes

http://www.postgresql.org/idocs/index.php?plpgsql-porting.html

This should help.

-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU -
http://www.brasileiro.net      http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
 
For Sale: Dehydrated H�O - $14 per quart