Re: Indexing UNIONs - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Indexing UNIONs
Date
Msg-id web-1578828@davinci.ethosmedia.com
Whole thread Raw
In response to Re: Indexing UNIONs  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: Indexing UNIONs
List pgsql-sql
Bruno,
> It wouldn't have to be a dummy table. You could have both sets of
> data
> in the same table. 

Per my original e-mail, this is not an option.

Basically, the two tables have nothing in commmon *except* that events
can be scheduled against either table.   Otherwise, the two tables have
vastly different data, which comes from completely different sources,
and is related to a totally different set of dependant tables.

So, no go.   

I run into this sort of thing a lot.  Is it just the way I design
databases, or is there a need for a more sophisticated model of
relationality for SQL03?

-Josh


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Cascading deletions does not seem to work inside PL/PGSQL
Next
From: Devrim GUNDUZ
Date:
Subject: A SQL Training