Re: quotes in pl/pgsql

From: clayton cottingham <drfrog(at)smartt(dot)com>
To: Najm Hashmi <najm(at)mondo-live(dot)com>
Cc: pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: quotes in pl/pgsql
Date: 2001-03-07 23:32:27
Message-ID: 3AA6C50B.2BCA7E52@smartt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.
> Thank you in advance.
>
> ------------------------------------------------------------------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

single qutoe escaping :

'here''s johnny'

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-03-08 00:08:13 Re: A query that doesn't work on 7.1
Previous Message Jia L Han 2001-03-07 23:15:43 ecpg on 7.0