[SQL] UNION and LIMIT issue

in pgsql 8.2 using LIMIT with UNION is throwing errors... table is --- name quantity character varying integer --- Banana 10 Cherry10 Apple 5 Persimmon

Re: [SQL] UNION and LIMIT issue

Howard Smith <[EMAIL PROTECTED]> writes: > SELECT name,quantity FROM fruit limit 3 > UNION >select name,CAST(SUM(quantity) as integer) from ( > select Cast('Other' as varchar) as name,quantity from fruit > limit ALL offset 3 >) w gro