Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U9LTY-00007p-89 for pgsql-sql@arkaria.postgresql.org; Sat, 23 Feb 2013 20:13:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1U9LTX-0002vd-Je for pgsql-sql@arkaria.postgresql.org; Sat, 23 Feb 2013 20:13:39 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U9LTV-0002vX-N6 for pgsql-sql@postgresql.org; Sat, 23 Feb 2013 20:13:38 +0000 Received: from isis.morrow.me.uk ([204.109.63.142]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U9LTT-0003oV-L7 for pgsql-sql@postgresql.org; Sat, 23 Feb 2013 20:13:36 +0000 Received: from anubis.morrow.me.uk (host109-150-212-220.range109-150.btcentralplus.com [109.150.212.220]) (Authenticated sender: mauzo) by isis.morrow.me.uk (Postfix) with ESMTPSA id 3BA5745046; Sat, 23 Feb 2013 20:13:33 +0000 (UTC) DKIM-Filter: OpenDKIM Filter v2.7.4 isis.morrow.me.uk 3BA5745046 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=morrow.me.uk; s=dkim201101; t=1361650414; bh=hCdysp+YpeWadyIAhPFY2mjA2NG4EGPR/I4ZO7Hc8c8=; h=Date:From:To:Subject:References:In-Reply-To; b=sVTT8+OXwrBmn5gv6yWPik/NDw2QbwX3hacHzKKgs47wl42YsBq9rywPykomia4zu en7HC3pKa/LWY+u8yZh2vJsYiP0q/FSkoL2QP1XL9/1xU7fuDENMqiknZvZMcjzLJn hdisgzPX80wwXvlhyIcBfTh4nh1unMeM0+Jkgjvw= X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.97.6 at isis.morrow.me.uk Received: by anubis.morrow.me.uk (Postfix, from userid 5001) id 17DAE9FB3; Sat, 23 Feb 2013 20:13:30 +0000 (GMT) Date: Sat, 23 Feb 2013 20:13:30 +0000 From: Ben Morrow To: parrisdc@gmail.com, pgsql-sql@postgresql.org Subject: Re: Summing & Grouping in a Hierarchical Structure Message-ID: <20130223201329.GA12863@anubis.morrow.me.uk> References: <8A586FDE-CC0A-4F26-AD19-1F89C2D9349E@uga.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Newsgroups: pgsql.sql Organization: morrow.me.uk User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org Quoth parrisdc@gmail.com (Don Parris): > > Is it possible to use spaces in the ltree path, like so: > TOP.Groceries.Food.Herbs & Spices > > Or do the elements of the path have to use underscores and dashes?