Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
You can enclose the names in quotes, then the characters are allowed Sorry to mislead you :p Best,Oliveiros ----- Original Message ----- From: Oliveiros CristinaTo: maria s ; Osvaldo Rosario Kussama ; pgsql-sql@postgresql.org ; Pavel Stehule ; Ivan Sergio BorgonovoSent: Tuesday, July 29, 2008 5:27 PMSubject: 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 sTo: Osvaldo Rosario Kussama ; pgsql-sql@postgresql.org ; Pavel Stehule ; Ivan Sergio BorgonovoSent: 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 abcBut I am getting ERROR: syntax error at or near "-" and also t "(" , ")"Can anyone help me to fix this?Thank you,Maria
----- Original Message ----- From: Oliveiros CristinaTo: maria s ; Osvaldo Rosario Kussama ; pgsql-sql@postgresql.org ; Pavel Stehule ; Ivan Sergio BorgonovoSent: Tuesday, July 29, 2008 5:27 PMSubject: 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 sTo: Osvaldo Rosario Kussama ; pgsql-sql@postgresql.org ; Pavel Stehule ; Ivan Sergio BorgonovoSent: 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 abcBut I am getting ERROR: syntax error at or near "-" and also t "(" , ")"Can anyone help me to fix this?Thank you,Maria
----- Original Message ----- From: maria sTo: Osvaldo Rosario Kussama ; pgsql-sql@postgresql.org ; Pavel Stehule ; Ivan Sergio BorgonovoSent: 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 abcBut I am getting ERROR: syntax error at or near "-" and also t "(" , ")"Can anyone help me to fix this?Thank you,Maria
В списке pgsql-sql по дате отправления: