Re: [GENERAL] query pegs beta4

2007-12-15 Thread Louis-David Mitterrand
On Sat, Dec 15, 2007 at 12:39:30PM -0500, Tom Lane wrote: > Louis-David Mitterrand <[EMAIL PROTECTED]> writes: > > This new query of mine pegs beta4, it doesn't return and CPU is at 100%: > > select l.id_location,l.name, > > a.city > > from location l, ad

Re: [GENERAL] query pegs beta4

2007-12-15 Thread Tom Lane
Louis-David Mitterrand <[EMAIL PROTECTED]> writes: > This new query of mine pegs beta4, it doesn't return and CPU is at 100%: > select l.id_location,l.name, > a.city > from location l, address a, show_date x, show s, show s2 >

[GENERAL] query pegs beta4

2007-12-15 Thread Louis-David Mitterrand
This new query of mine pegs beta4, it doesn't return and CPU is at 100%: select l.id_location,l.name, a.city from location l, address a, show_date x, show s, show s2 where (l.id_address = a.id_address