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 |
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 |