Skip site navigation (1) Skip section navigation (2)

Re: column names with - and (

From: "maria s" <psmg01(at)gmail(dot)com>
To: "Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt>
Cc: "Osvaldo Rosario Kussama" <osvaldo(dot)kussama(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org, "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>, "Ivan Sergio Borgonovo" <mail(at)webthatworks(dot)it>
Subject: Re: column names with - and (
Date: 2008-07-29 16:35:40
Message-ID: d9d42a0f0807290935xf7ecb40o241c5db1926b98fd@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(dot)cristina(at)marktest(dot)pt> wrote:

>  Maria,
>
> The minus, open bracket and close bracket are illegal as identifier names
>
>
> http://www.postgresql.org/docs/8.3/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
>
> Best,
> Oliveiros
>
>
> ----- Original Message -----
> *From:* maria s <psmg01(at)gmail(dot)com>
> *To:* Osvaldo Rosario Kussama <osvaldo(dot)kussama(at)gmail(dot)com> ;
> pgsql-sql(at)postgresql(dot)org ; Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> ; Ivan
> Sergio Borgonovo <mail(at)webthatworks(dot)it>
> *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
>
>

In response to

pgsql-sql by date

Next:From: Oliveiros CristinaDate: 2008-07-29 16:37:06
Subject: Re: column names with - and (
Previous:From: Oliveiros CristinaDate: 2008-07-29 16:27:38
Subject: Re: column names with - and (

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group