The magic you're looking for is UNION ALL.
You could just union the two address tables together and join that to
the address code table, but that'll probably lead to an inefficient
plan. You'll likely need to join the address code table to each address
table separately, and then UNION ALL those to
Bizgres/Greenplum is about as close as you'll get, unless you're talking
about replication ("distributed database" isn't exactly a standard
term).
On Mon, Apr 09, 2007 at 02:38:18AM -0700, s kh wrote:
> hi,
> I have a question about distributed databases,
> can we have a ditributed posgresql datab
Yes, Here's the results table
name | setting | unit | category |
short_desc| ex
tra_desc | context | vartype | source | min_val |
max_val
-+-
I have postgres 8.1 on WindowsXP, installed via postgres installer. I
have the user postgres on the cluster. When I try to create database
from command line:
createdb -U postgres test_db_1
I get error that 'postgres database does not exists'. When I try to
create db from EMS manager, everything w
