Postgres Pro
Downloads
Home   >   mailing lists

Re: problems with single quotes.. - Mailing list pgsql-sql

From Roberto Mello
Subject Re: problems with single quotes..
Date
Msg-id 20011202152504.B25485@cc.usu.edu
Whole thread Raw
In response to Re: problems with single quotes..  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "postgresql"
Date:
Subject: Re: problems with single quotes..
Next
From: Stephan Szabo
Date:
Subject: Re: problems with single quotes..