Subject Re: Converting to FB2: PSQL aliases
Author russellbelding
Thanks Helen.
So far RB2 RC1 is fine, in doing testing as I convert SQL Statements
and some COMMENT field names to another name. No problems seen.

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:
>
> 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
>