Underscores in column names

From: Mark Mitchell <mark(at)lapcrew(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Underscores in column names
Date: 2003-03-07 15:58:00
Message-ID: 1047052681.24305.6.camel@sql.icnfull.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2003-03-07 16:17:36 Re: Help on indexing timestamps
Previous Message Achilleus Mantzios 2003-03-07 15:48:04 Re: Help on indexing timestamps