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 namesBest,Oliveiros----- Original Message -----From: maria sSent: Tuesday, July 29, 2008 5:06 PMSubject: [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 по дате отправления: