Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-27 Thread Peter Eisentraut
Jonah H. Harris wrote: I'm not saying that *everything* on pgfoundry is junk... but I can start naming dead projects if you'd like. Well, make a list and tell the admins to delete those projects. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-27 Thread Jonah H. Harris
On 8/27/06, Peter Eisentraut [EMAIL PROTECTED] wrote: Well, make a list and tell the admins to delete those projects. Alright. When I come across one, I'll forward it on. -- Jonah H. Harris, Software Architect | phone: 732.331.1300 EnterpriseDB Corporation| fax: 732.331.1301 33

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-14 Thread Joshua D. Drake
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. You could announce it

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread Bruce Momjian
Jonah H. Harris wrote: On 8/12/06, Tom Lane [EMAIL PROTECTED] wrote: More seriously: the current state of affairs is that the full-disjunction code exists as a pgfoundry project. If it's indeed the second greatest thing since sliced bread, then I think we could assume that people will

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread David Fetter
On Sun, Aug 13, 2006 at 10:07:06AM -0400, Bruce Momjian wrote: Jonah H. Harris wrote: On 8/12/06, Tom Lane [EMAIL PROTECTED] wrote: More seriously: the current state of affairs is that the full-disjunction code exists as a pgfoundry project. If it's indeed the second greatest thing

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread Bruce Momjian
David Fetter wrote: Our distribution is not a place to experiment with things. That's what separate pgfoundry projects are for. The fact we have some unusual things in /contrib is not a reason to add more. If it's on track to become part of PostgreSQL, as other innovative features have

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread David Fetter
On Sun, Aug 13, 2006 at 11:45:43AM -0400, Bruce Momjian wrote: David Fetter wrote: Our distribution is not a place to experiment with things. That's what separate pgfoundry projects are for. The fact we have some unusual things in /contrib is not a reason to add more. If it's on

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread Tom Lane
Jonah H. Harris [EMAIL PROTECTED] writes: I don't see the harm in including this one for at least this release. If no one uses it, take it out for 8.3. Once stuff is in contrib, it tends to stay there. The above argument is completely disingenuous --- we'd have to have the same argument again

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread Andrew Dunstan
David Fetter wrote: If it were just me laying out the boundary, I'd say that anything that changes the grammar of SQL--for example, adding FULL DISJUNCTION--can't really be a viable trial outside the main distribution channels and deserves a couple of versions' stay in one of those channels if

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread Tom Lane
David Fetter [EMAIL PROTECTED] writes: If it were just me laying out the boundary, I'd say that anything that changes the grammar of SQL--for example, adding FULL DISJUNCTION--can't really be a viable trial outside the main distribution channels and deserves a couple of versions' stay in one

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread Josh Berkus
Bruce Momjian wrote: I am still waiting for someone to tell us that they would use this capability for a real-world problem. It's extremely useful for data mining and data consolidation where you're given messy or sparse data to clean up and present intelligently. For example, if it had

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread Josh Berkus
Tom, The case for FD seems to be basically if you build it they will come, and I'm sorry but I'm not sold. If it gets some traction as a pgfoundry project then we could look at doing a second-generation implementation in a form that could actually get into core... but until then I'm inclined

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread Jonah H. Harris
On 8/13/06, Josh Berkus josh@agliodbs.com wrote: My sentiments exactly. -- Jonah H. Harris, Software Architect | phone: 732.331.1300 EnterpriseDB Corporation| fax: 732.331.1301 33 Wood Ave S, 2nd Floor| [EMAIL PROTECTED] Iselin, New Jersey 08830|

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread Dave Page
Fetter [EMAIL PROTECTED]; Bruce Momjian [EMAIL PROTECTED]; Jonah H. Harris [EMAIL PROTECTED]; AgentM [EMAIL PROTECTED]; PostgreSQL-development pgsql-hackers@postgresql.org Sent: 13/08/06 22:01 Subject: Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib Tom, The case for FD seems

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread Tom Lane
Josh Berkus josh@agliodbs.com writes: Bruce Momjian wrote: I am still waiting for someone to tell us that they would use this capability for a real-world problem. It's extremely useful for data mining and data consolidation where you're given messy or sparse data to clean up and present

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread Tom Lane
Josh Berkus josh@agliodbs.com writes: The reason why it makes sense for FD to be in /contrib is that if it works out it will be a new join type, which is definitely core-code stuff. You seem to have missed my point, which is that implementation as a new join type would probably have nothing in

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread Josh Berkus
Tom, 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

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread Andrew Dunstan
Josh Berkus wrote: 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. I don't see that

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: Josh Berkus wrote: 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

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-12 Thread Bruce Momjian
I am still waiting for someone to tell us that they would use this capability for a real-world problem. --- Tzahi Fadida wrote: On Friday 11 August 2006 07:18, Bruce Momjian wrote: I have looked over this addition, and I

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-12 Thread Tzahi Fadida
On Friday 11 August 2006 07:18, Bruce Momjian wrote: I have looked over this addition, and I think I finally understand it. Given three tables, A, B, C, which join as A-B, B-C, C-A, you can really join them as A-B-C, and A-C-B. What full disjunction does is to perform both of those joins, and

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-12 Thread Tzahi Fadida
On Saturday 12 August 2006 07:22, Bruce Momjian wrote: I am still waiting for someone to tell us that they would use this capability for a real-world problem. I suggest looking into web applications. The example here http://www.technion.ac.il/~tzahi/soc.html shows a possible 3 separate web

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-12 Thread AgentM
On Aug 12, 2006, at 6:01 , Tzahi Fadida wrote: On Saturday 12 August 2006 07:22, Bruce Momjian wrote: I am still waiting for someone to tell us that they would use this capability for a real-world problem. Notice that if you google full disjunction that the first link is this project.

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-12 Thread Bruce Momjian
AgentM wrote: On Aug 12, 2006, at 6:01 , Tzahi Fadida wrote: On Saturday 12 August 2006 07:22, Bruce Momjian wrote: I am still waiting for someone to tell us that they would use this capability for a real-world problem. Notice that if you google full disjunction that the first link

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-12 Thread Tom Lane
AgentM [EMAIL PROTECTED] writes: You won't find anyone to vouch for it because this is the first implementation of full disjunctions in any database. That doesn't mean it isn't useful- it means no one is using it because it hasn't existed until now. This is the point where one needs to

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-12 Thread Jonah H. Harris
On 8/12/06, Tom Lane [EMAIL PROTECTED] wrote: More seriously: the current state of affairs is that the full-disjunction code exists as a pgfoundry project. If it's indeed the second greatest thing since sliced bread, then I think we could assume that people will find it and use it from

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-10 Thread Bruce Momjian
I have looked over this addition, and I think I finally understand it. Given three tables, A, B, C, which join as A-B, B-C, C-A, you can really join them as A-B-C, and A-C-B. What full disjunction does is to perform both of those joins, and return a one row for each join. Here is an example