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