Re: quotes in pl/pgsql 0n variable type text or varchar

From: Najm Hashmi <najm(at)mondo-live(dot)com>
To: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
Cc: pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: quotes in pl/pgsql 0n variable type text or varchar
Date: 2001-03-09 16:18:53
Message-ID: 3AA9026C.86D545FE@mondo-live.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Roberto Mello wrote:

> 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

Hi, I just want to know is there way to put single quotes around the value
of var type text or varchar.
Thanks in advance.
Regards.

Attachment Content-Type Size
najm.vcf text/x-vcard 184 bytes

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Creager, Robert S 2001-03-09 16:21:32 cannot get CREATE TABLE AS to work
Previous Message Johan Van den Brande 2001-03-09 15:03:25 Re: perl dbd