pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedAS?
2+ messages / 2 participants
[nested] [flat]
* AS?
@ 2003-05-19 15:55 Andreas Selenwall <asl01003@student.mdh.se>
0 siblings, 1 reply; 2+ messages in thread
From: Andreas Selenwall @ 2003-05-19 15:55 UTC (permalink / raw)
To: pgsql-sql
How do I use AS?
I want to do a JOIN but I have two columns with the same name. I thought that postgresql might solve this as ACCESS does, by giving the columns names like Table1.id and Table2.id, but he didn't.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: AS?
@ 2003-05-23 01:48 Bruno Wolff III <bruno@wolff.to>
parent: Andreas Selenwall <asl01003@student.mdh.se>
0 siblings, 0 replies; 2+ messages in thread
From: Bruno Wolff III @ 2003-05-23 01:48 UTC (permalink / raw)
To: Andreas Selenwall <asl01003@student.mdh.se>; +Cc: pgsql-sql
On Mon, May 19, 2003 at 16:55:06 +0100,
Andreas Selenwall <asl01003@student.mdh.se> wrote:
> How do I use AS?
> I want to do a JOIN but I have two columns with the same name. I thought that postgresql might solve this as ACCESS does, by giving the columns names like Table1.id and Table2.id, but he didn't.
You should be able to qualify the column names with the table names.
Why don't you show us what you did and what results you got.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-05-23 01:48 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-19 15:55 AS? Andreas Selenwall <asl01003@student.mdh.se>
2003-05-23 01:48 ` Bruno Wolff III <bruno@wolff.to>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox