Re: [SQL] problem with subqueries

2002-10-06 Thread pete
try some of the suggestions later on today (such as placing the distinct clause at the end) but first I have to go and get some decorating done :-( (yes, that sound you can hear is the crack of my wife's whip!). Regards, Pete -- I do whatever the Voices tell me to do --

[SQL] problem with subqueries

2002-10-05 Thread pete
ng the top of the chart! I have to ^C to interrupt it, as it runs for ages (I've left this run for 10-20 minutes and it is still running). I have indexes on the columns involved from the original tables. Any help appreciated. Pete PS: Using pgsql 7.2-70 from Suse distribution.