From: Mark Mitchell <mark@lapcrew.com>
To: pgsql-sql@postgresql.org
Subject: Underscores in column names
Date: 07 Mar 2003 10:58:00 -0500
Message-ID: <1047052681.24305.6.camel@sql.icnfull.com> (raw)
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?
- Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mark@lapcrew.com
Subject: Re: Underscores in column names
In-Reply-To: <1047052681.24305.6.camel@sql.icnfull.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox