Re: table.column in query results?

--- On Thu, 7/23/09, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:

> Andrew Klaassen wrote:
> > Is it possible to get table.column in query results
> rather
> > than just column?
> >
> > I.e. I'd like:
> >
> > SELECT * FROM foo, bar;
> > foo.id | foo.name | bar.id | bar.text
> > -------+----------+--------+---------
> > ...
> >
> > ...rather than:
> >
> > SELECT * FROM foo, bar;
> > id | name | id | text
> > ---+------+----+-----
> > ...
>
> You'd have to use aliases, like
>
> SELECT id AS "foo.id" ...

Ah... so no way to do it with a wildcard in the query?

That's unfortunate.

Thanks.

Andrew

__________________________________________________________________
The new Internet Explorer® 8 - Faster, safer, easier. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/