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 < [EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > *To:* Osvaldo Rosario Kussama <[EMAIL PROTECTED]> ; > pgsql-sql@postgresql.org ; Pavel Stehule <[EMAIL PROTECTED]> ; Ivan > Sergio Borgonovo <[EMAIL PROTECTED]> > *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 > >
