Home → FlySpeed SQL Query → Postgresql substring
Postgresql substring
|
Hello, I'm currently using version 2.9.4.2. Running my query from PostgreSQL9 generates the next error message: Invalid SELECT statement Unexpected token "," at line 33, pos 35 The 33th line is contain this: substring(fktranz_fej.megjegyzes, 4) As kif1, WUsing it vith earlier versions, works fine. thx, Csaba |
|
Ragasits Csaba
| email
September 13 2011, 05:57 AM |
|
Thank you for the bug report. According to PostgreSql docs, the only valid syntax for SUBSTRNIG function is SUBSTRING(string FROM number [FOR number]), and we change our parser to support this syntax only. But actually PostgreSql server understand the form with commas, and since version 2.9.4.4 our sql parser can parse such second form without errors. |
|
Vitaly Sotnikov
| email
1 week, 1 day since original post |
|
Thank Your answer, I've tested it the 2.9.4.4 version, it's working fine. |
|
Ragasits Csaba
| email
1 week, 1 day since original post |