Re: [GENERAL] UNION messing up sorting WAS: psql performance

2005-04-14 Thread Jim C. Nasby
On Fri, Apr 15, 2005 at 12:23:14AM -0400, Joseph Shraibman wrote: > > > Alvaro Herrera wrote: > > >>Incidentally when I did that I only got back one row. What's up with > >>that? > > > > > >Try with "union all" instead of plain union. > > > Talk about serendipity. The problem I've been strugg

[GENERAL] UNION messing up sorting WAS: psql performance

2005-04-14 Thread Joseph Shraibman
Alvaro Herrera wrote: Incidentally when I did that I only got back one row. What's up with that? Try with "union all" instead of plain union. Talk about serendipity. The problem I've been struggling with for the last few hours has been why my query wasn't producing sorted output even though I