syntax error at or near ":"

[apostol]

I try to execute SQL query in ZQuery:

Code: Select all

SELECT lanname,	lanpltrusted,lanplcallfoid::regproc AS lanplcallf  FROM pg_language WHERE lanispl ORDER BY lanname;

ERROR: syntax error at or near ":".

How much I have understood a problem is covered in "::".

IDE: BCB5; DB: PostgreSQL 8.1.5 - 8.2.4; Components ZEOSLIB_TESTING_REV261

Help to solve this problem.

[btrewern]

Try

Code: Select all

SELECT lanname,   regproc(lanpltrusted,lanplcallfoid) AS lanplcallf  FROM pg_language WHERE lanispl ORDER BY lanname;

Regards,

Ben

[apostol]

Try

Code: Select all

SELECT lanname,   regproc(lanpltrusted,lanplcallfoid) AS lanplcallf  FROM pg_language WHERE lanispl ORDER BY lanname;

Regards,
Ben

So will be more correct

Code: Select all

SELECT lanname,  lanpltrusted, regproc(lanplcallfoid) AS lanplcallf  FROM pg_language WHERE lanispl ORDER BY lanname;

I and did. But it would be desirable, that there was a support "::" in ZEOS.