On Fri, Jul 23, 2004 at 02:48:01 -0700,
CSN <[EMAIL PROTECTED]> wrote:
> Is it possible to automatically prefix a table alias
> (or table name or something else even) to each column
> in a select list? For example:
>
> select a.*, b.*
> from tablea a
> inner tableb b
> on a.id=b.aid;
>
> results:
>
> a_id, a_name, b_id, b_name, b_aid
I don't know of any Postgres feature that allows for computed aliases
at the SQL level. If the SQL is being generated by a program, the
program could potentially do this for you.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
