> Could we see a concrete, real-world example?  So far I've seen a lot of
> arm-waving but nothing very specific.

Sure.  Imagine that you work for an arts nonprofit and you have 3 (or more) 
separate box office lists from last season, each of which has different 
amounts of contact information.  You want to get "best of" the information 
-- that is, address if it's available, zip if it's there, phone if it's 
there, etc.    FD will reduce that process from several procedural loops 
to a single query for the first pre-deduplication run.

Or, imagine that you have 5 weblogs in different formats from 5 different 
servers.   Due to the different logging/site design, you have and lack 
different information from each log.  You want to munge all of the data 
together to extract the maximum amount of data about each visitor you can 
get, without having multiple records per visit.

This supposition holds true for court records, customer records, etc ... 
anywhere you may have relational data with a high degree of incompleteness 
from different sources ... something I encountered on about 30% of all the 
DB development projects I worked on.

> You seem to have missed my point, which is that implementation as a new
> join type would probably have nothing in common with the
> externally-coded version.  The one and only reason for it to be in
> contrib instead of on pgfoundry is that you think it will get more
> attention that way. Which might be true, but it's a fairly weak argument
> for asking the core developers to take on maintenance and bug-fixing for
> what is ultimately going to be a dead-end code base.  

OK, point taken.  I'll admit that I had hopes for it for PR reasons, which 
is not usually why we make decisions.  It would be cool to be the first 
database system to ship with any implementation of Full Disjunctions, and 
I can't announce that if it's on pgFoundry.


Josh Berkus
PostgreSQL @ Sun
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to