Re: select, columns, and aliases

???

--- Michael Kleiser <mkl@webde-ag.de> wrote:
> select a.*, b.*
>   from tablea AS a
>   inner tableb AS b
>   on a.id=b.aid;
>
>
> CSN schrieb:
> > 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
> >
> >
> > CSN
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Vote for the stars of Yahoo!'s next ad campaign!
> >
>
http://advision.webevents.yahoo.com/yahoo/votelifeengine/
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the
> unregister command
> >     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com