Zeoslib Portal

Posted: **08.08.2007, 18:10**

I try to execute SQL query in ZQuery:

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.

Posted: **13.08.2007, 15:33**

Try

Code: Select all

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

Regards,

Ben

Posted: **13.08.2007, 16:57**

btrewern wrote: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.