Re: column names with - and (

Поиск
Список
Период
Сортировка
От maria s
Тема Re: column names with - and (
Дата
Msg-id d9d42a0f0807290935xf7ecb40o241c5db1926b98fd@mail.gmail.com
обсуждение исходный текст
Ответ на Re: column names with - and (  ("Oliveiros Cristina" <oliveiros.cristina@marktest.pt>)
Список pgsql-sql

Hi Oliveiros,
Thanks for the link. Yes I read it.

But I am using "" for the column names. So now I am getting the result that I need.

Thanks for all your help.

Maria

On Tue, Jul 29, 2008 at 12:27 PM, Oliveiros Cristina <oliveiros.cristina@marktest.pt> wrote:
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 по дате отправления:

Предыдущее
От: "Oliveiros Cristina"
Дата:
Сообщение: Re: column names with - and (
Следующее
От: "Oliveiros Cristina"
Дата:
Сообщение: Re: column names with - and (