Using column aliases in SELECT

PostgreSQL expects the ANSI notation for column aliases:

SELECT col1 AS col1_alias FROM ...

Informix® supports the ANSI notation.

Solution

The database interface cannot convert Informix alias specification to the ANSI notation.

Review your programs and replace the Informix notation with the ANSI form.