From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | deriving a column from union |
Date: | 2002-01-03 23:02:55 |
Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB0452DC42@snt452.corp.bcbsm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Howdy:
Silly question:
I am creating a table. Inside this table, I am trying to create a new
column derived from two other columns from two different tables
(by the way, both have the same name).
[example]
select a.type from dates a union select b.type from systems b;
[/example]
This LOOKS like it could work, except when I try to do it, it takes
quite a bit of time (as a matter of fact, I just cancelled it for the second
time because 20 minutes is TOO long for what I need to do).
Is there a speedier way to merge those two columns into a single
column?
Thanks!
-X
From | Date | Subject | |
---|---|---|---|
Next Message | Roderick A. Anderson | 2002-01-03 23:29:36 | Re: Simplicity in time/date functions |
Previous Message | Chris Albertson | 2002-01-03 22:28:49 | Re: Shipping database help desperately needed |