Re: problems with single quotes..

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Megalex <megalex(at)klanomega(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: problems with single quotes..
Date: 2001-12-02 22:25:04
Message-ID: 20011202152504.B25485@cc.usu.edu
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 HO - $14 per quart

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message postgresql 2001-12-03 03:20:48 Re: problems with single quotes..
Previous Message Stephan Szabo 2001-12-02 22:21:33 Re: problems with single quotes..