Re: quotes in pl/pgsql - Mailing list pgsql-sql

From Roberto Mello
Subject Re: quotes in pl/pgsql
Date
Msg-id 20010307180354.A20006@cc.usu.edu
Whole thread Raw
In response to quotes in pl/pgsql  (Najm Hashmi <najm@mondo-live.com>)
List pgsql-sql
On Thu, Mar 08, 2001 at 05:54:38PM -0500, Najm Hashmi wrote:
> Hi all, I just want to know how to put quotes around a string. Is there a
> function to do so?
> If not how can I escape  a single quote.
Others have answered how to quote a single string. I wrote an entire
section on quotes on the PL/SQL-to-PL/pgSQL-HOWTO. It's called "Quote me
on that" and mentions several cases on quote usage in PL/pgSQL and what to
do about it.http://www.brasileiro.net/roberto/howto
-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, Web Developer    
 
DOS = Damned Old Software


pgsql-sql by date:

Previous
From: Justin Clift
Date:
Subject: Re: quotes in pl/pgsql
Next
From: Tom Lane
Date:
Subject: Re: A query that doesn't work on 7.1