Re: column names with - and ( - Mailing list pgsql-sql

From maria s
Subject Re: column names with - and (
Date
Msg-id d9d42a0f0807290939g3436a2cdx127a17d4b42d94c0@mail.gmail.com
Whole thread Raw
In response to Re: column names with - and (  ("Oliveiros Cristina" <oliveiros.cristina@marktest.pt>)
List pgsql-sql
Its okay, Yes I am using quotes. Michael was telling that too.

Thanks for all the help at all times.

Maria


On Tue, Jul 29, 2008 at 12:37 PM, Oliveiros Cristina <oliveiros.cristina@marktest.pt> wrote:
You can enclose the names in quotes, then the characters are allowed
 
Sorry to mislead you :p
 
Best,
Oliveiros
 
 
----- Original Message -----
Sent: Tuesday, July 29, 2008 5:27 PM
Subject: Re: [SQL] column names with - and (

Maria,
 
The minus, open bracket and close bracket are illegal as identifier names
 
 
Best,
Oliveiros
 
----- Original Message -----
From: maria s
Sent: Tuesday, July 29, 2008 5:06 PM
Subject: [SQL] column names with - and (

Hi All,
When I am fetching the data from a table,
I am giving the column names with - and ( and ) like IL-a, IL-a(p30) etc..

select x1 as IL-a, x2 as IL-a(p30) from abc

But I am getting

ERROR:  syntax error at or near "-" and also t "(" , ")"

Can anyone help me to fix this?

Thank you,
Maria

pgsql-sql by date:

Previous
From: "Oliveiros Cristina"
Date:
Subject: Re: column names with - and (
Next
From: Ryan Wallace
Date:
Subject: Identifying which column matches a full text search