Re: [GENERAL] ' syntax

From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
To: "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com>, amarof <amarof(at)marwan(dot)ac(dot)ma>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] ' syntax
Date: 1999-06-01 15:05:34
Message-ID: l03130303b379a6fe76e5@[147.233.159.109]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 21:24 +0300 on 01/06/1999, Brett W. McCoy wrote:

> Precede the character with a backslash:
>
> mystring\'s
> dotorat d\'etat

The standard is doubling the quote:

mystring''s
dorctorat d''etat

Backslashes are specific to PostgreSQL, and I don't recommend them.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael J Davis 1999-06-01 15:33:42 RE: [GENERAL][SQL] 'denormalising' with a select
Previous Message John Browning 1999-06-01 14:59:37 Re: [GENERAL] ' syntax