Message-ID: <3E5393E5.6050901@pqrs.de>
Date: Wed, 19 Feb 2003 15:25:41 +0100
From: Axel Schlueter <axel@pqrs.de>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3b) Gecko/20030211
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Default column titles in a select...
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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'"