On Thu, Apr 14, 2005 at 08:17:55PM -0700, Joshua D. Drake wrote: > Joseph Shraibman wrote: > >It doesn't matter what the query is. The problem happens before it even > >runs the query. Just try pasting select > >'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > >'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > >'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > > I can not reproduce your problem on 8.0.2. Nor I with 7.2.7, 7.3.9, 7.4.7, 8.0.2, or 8.1devel. What happens if you edit the query with \e and then issue it, or if you put the query in a file and use \i to read it? Could you tell us something about your environment -- OS, window manager, terminal, etc.? > >Incidentally when I did that I only got back one row. What's up with that? That's how UNION works: http://www.postgresql.org/docs/7.4/interactive/queries-union.html "Furthermore, it eliminates all duplicate rows, in the sense of DISTINCT, unless UNION ALL is used." -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
