Chris Bitmead <chris@tech.com.au> writes:
> Is it a known problem that LIMIT doesn't work with UNION, or have I
> discovered a bug?
Not sure, but I think the LIMIT would be parsed as an attribute of
one or the other of the sub-selects, not as a limit on the total
result size. This is probably not the behavior you want :-(
regards, tom lane