Search found 3 matches
- 13.08.2007, 16:57
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: syntax error at or near ":"
- Replies: 2
- Views: 943
Try SELECT lanname, regproc(lanpltrusted,lanplcallfoid) AS lanplcallf FROM pg_language WHERE lanispl ORDER BY lanname; Regards, Ben So will be more correct :) SELECT lanname, lanpltrusted, regproc(lanplcallfoid) AS lanplcallf FROM pg_language WHERE lanispl ORDER BY lanname; I and did. But it would ...
- 08.08.2007, 18:10
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: syntax error at or near ":"
- Replies: 2
- Views: 943
syntax error at or near ":"
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 -...
- 12.06.2007, 10:58
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: Problem with type of a field _aclitem in PostgreSQL
- Replies: 0
- Views: 764
Problem with type of a field _aclitem in PostgreSQL
In advance I apologize for my English:) I try to execute inquiry of a kind Select datname,datdba,datacl from pg_database; Performance of inquiry leads to a mistake: Cannot access blob record in column 3 with type string. How much I have understood a problem is covered in type of a field _aclitem. ID...