Message-ID: <469FDF17.9060701@visualmining.com>
Date: Thu, 19 Jul 2007 18:00:55 -0400
From: Howard Smith <hsmith@visualmining.com>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: UNION and LIMIT issue
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

in pgsql 8.2 using LIMIT with UNION is throwing errors...

table is
-------------------------------

name                       quantity
character varying     integer
-------------------------------
Banana                   10
Cherry                    10
Apple                     5
Persimmon              3
Mango                    2

the query :

      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   group by name

throws an error on the UNION. Removing the first 'Limit 3' fixes the query,
but i need the limit statement. Anybody seen this behavior?

-- 
Howard Smith
professional services engineer
Visual Mining Inc
15825 Shady Grove Road, Suite 20
Rockville, MD 20850
tel 301.795.2239  fax 301.947.8293