Default column titles in a select...

From: Axel Schlueter <axel(at)pqrs(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Default column titles in a select...
Date: 2003-02-19 14:25:41
Message-ID: 3E5393E5.6050901@pqrs.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

maybe it's a novice question, but I stumpled across
the following problem and couldn't find a solution:

create table c(
atext varchar
);

create table a(
objid smallint,
)INHERITS(c);

create table b(
objid smallint,
)INHERITS(c);

insert into a values(1,'foobar');
insert into b values(1,'carcddr');

When doing the following select statement:
select * from a,b where a.objid=b.objid
postgresql returns four columns labeled
objid atext objid atext
instead of what I expected:
a.objid a.atext b.objid b.atext

With the current result I'm unable to differentiate
between the two 'atext' column. Is there any possibility
to get column headers including the table name in the
result ?

Bye,
Axel
--
"The virus spreads using a Microsoft
vulnerability known as 'MS SQL Server'"

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message greg 2003-02-19 15:07:07 Re: Default column titles in a select...
Previous Message Christoph Haller 2003-02-19 13:04:26 Re: " Adding missing FROM-clause entry for table .... " problem.