The minus, open bracket and close bracket are illegal as identifier names
----- Original Message -----
From: maria s
To: Osvaldo Rosario Kussama ; pgsql-sql(at)postgresql(dot)org ; Pavel Stehule ; Ivan Sergio Borgonovo
Sent: Tuesday, July 29, 2008 5:06 PM
Subject: [SQL] column names with - and (
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?
In response to
pgsql-sql by date
|Next:||From: maria s||Date: 2008-07-29 16:35:40|
|Subject: Re: column names with - and (|
|Previous:||From: maria s||Date: 2008-07-29 16:06:57|
|Subject: column names with - and (|