Its okay, Yes I am using quotes. Michael was telling that too. Thanks for all the help at all times.
Maria On Tue, Jul 29, 2008 at 12:37 PM, Oliveiros Cristina < [EMAIL PROTECTED]> wrote: > You can enclose the names in quotes, then the characters are allowed > > Sorry to mislead you :p > > Best, > Oliveiros > > > > ----- Original Message ----- > *From:* Oliveiros Cristina <[EMAIL PROTECTED]> > *To:* maria s <[EMAIL PROTECTED]> ; Osvaldo Rosario Kussama<[EMAIL > PROTECTED]>; > pgsql-sql@postgresql.org ; Pavel Stehule <[EMAIL PROTECTED]> ; Ivan > Sergio Borgonovo <[EMAIL PROTECTED]> > *Sent:* Tuesday, July 29, 2008 5:27 PM > *Subject:* Re: [SQL] column names with - and ( > > 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 > >
