HomeFlySpeed SQL QueryPostgresql 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
This topic is closed