No, it is not possible. Column number is only allowed in ORDER clause.
In any case, using column names in SQL statement practically do not affect to the performance in comparison to the time to retrieve the data.

--- In firebird-support@yahoogroups.com, "Olaf Kluge" <olaf.kluge@...> wrote:
>
> Hello again,
>
>
>
> we have some workstations. Every ws need to show some fields of an table.
> Now I thought, I can configure that with the numbers of the column. I also
> could write down the column-Names in a configuration table, but sql
> statements should be slower.
>
>
>
> Thanks for helping.
>
>
>
>
>
> Olaf
>
>
>
> Hello,
>
> it is possible to select the column by column-number? For example:
> Column1=ID, column2 = name, column3 = address. And now: "select column(2),
> column(3) from table". Orderby column-number is already possible.
>
> Thank you.
>
> Best regards.
>
> Olaf
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>