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.
begin:vcard n:Hashmi;Najm x-mozilla-html:FALSE org:Mondo-Live.com;www.flipr.com adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] x-mozilla-cpt:;6144 fn:Najm Hashmi end:vcard
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
