Parent topic: Data manipulation
SQL adaptation guide For PostgreSQL 8.x.y, 9.x.y / Data manipulation

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.

Parent topic: Data manipulation