Re: #escape_string_warning = off

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Jeff Davis <jdavis-pgsql(at)empires(dot)org>
Cc: Marko Kreen <marko(at)l-t(dot)ee>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: #escape_string_warning = off
Date: 2005-08-02 07:39:36
Message-ID: Pine.LNX.4.44.0508020936361.2995-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 1 Aug 2005, Jeff Davis wrote:

> Does the SQL standard provide no way to have a NULL character in a
> string constant? Is single-quote the only special character?

I don't think it forbids you from using the null character. It's not like
the strings are zero terminated. Some encodings might not allow the null
character, but that's different.

ps. null character does not have anything to do with the sql NULL. I'm
sure there is someone somewhere that need this info.

--
/Dennis Björklund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2005-08-02 07:57:34 Re: #escape_string_warning = off
Previous Message Jeff MacDonald 2005-08-02 07:31:03 Re: Autovacuum to-do list