At 01:42 PM 15/04/2006, you wrote:

>In converting an application from FB 1.5.x to 2.0 I am eliminating all
>aliases from my client code because of the new alias rule that
>eliminates ambiguities. "if an alias for a table is used it must be
>used always in place of the table name." Its straightforward and safe.
>
>In the FB2 RC1 release notes under PSQL this rule is not stated or I
>have missed it. I suppose PSQL is SQL? The ambuguities of SQL can be
>carried to PSQL.
>
>Does the new table alias rule apply to PSQL? I assume it does but
>welcome some better insight.

All rules that apply to SQL statement syntax apply to the equivalent
statements used in PSQL - that has never changed. PSQL consists of
DSQL plus programming extensions. For example, the [FOR] SELECT
<specs> INTO... <vars> syntax is a programming extension of SELECT
syntax particular to PSQL, the rules for the specification remain the
same as for the dynamic (and, indeed, the static) implementation.

If you are seeing conflicting behaviour, please submit a reproducible
test case to firebird-devel.

./heLen