Content-Type: text/plain;
  charset="utf-8"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: Mark Mitchell <mark@lapcrew.com>, pgsql-sql@postgresql.org
Subject: Re: Underscores in column names
Date: Fri, 7 Mar 2003 16:28:11 +0000
User-Agent: KMail/1.4.3
References: <1047052681.24305.6.camel@sql.icnfull.com>
In-Reply-To: <1047052681.24305.6.camel@sql.icnfull.com>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200303071628.11980.dev@archonet.com>

On Friday 07 Mar 2003 3:58 pm, Mark Mitchell wrote:
> I have a underscores in most all of the column names in this database.
> I've ran into a problem where Postgres doesn't like them.
>
> SELECT * FROM "NATAB" WHERE
> "NATAB"."NA_LAST_NAME" LIKE 'MITCHELL%' AND
> SUBSTRING("NATAB"."NA_NAME",0,"NATAB"."NA_COLON") LIKE 'MARK%'
>
> Produces the error : "ESCAPE string must be empty or one character"
>
> The column "NA_COLON" is a column that holds the numeric position at
> which the first name ends and the last name begins. If the column name
> does not contain an underscore it works fine. Any suggestions?

Are you sure you don't mean substr() rather than substring()? I think the f=
orm=20
you're using does a POSIX regexp match and uses the third param as an escap=
e=20
character.

--=20
  Richard Huxton