X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B3D2ED1DB0A for ; Thu, 15 Apr 2004 01:21:18 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 38724-03 for ; Thu, 15 Apr 2004 01:21:17 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id D9085D1D8AE for ; Thu, 15 Apr 2004 01:21:16 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i3F4LF3E011792; Thu, 15 Apr 2004 00:21:15 -0400 (EDT) To: "Donald Fraser" Cc: "[ADMIN]" Subject: Re: Updgrade from 7.3 to 7.4 In-reply-to: <006701c42223$2dfe5960$1664a8c0@DEMOLITION> References: <006701c42223$2dfe5960$1664a8c0@DEMOLITION> Comments: In-reply-to "Donald Fraser" message dated "Wed, 14 Apr 2004 14:19:55 +0100" Date: Thu, 15 Apr 2004 00:21:14 -0400 Message-ID: <11791.1082002874@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/226 X-Sequence-Number: 13199 "Donald Fraser" writes: > 2) One of my queries does an ORDER BY on a column that is of type BOX. > This query no longer runs and returns the following error message: > ERROR: could not identify an ordering operator for type box What are you expecting that to do? Boxes have no natural linear ordering. > my_box[0] returns a point and my_box[0][0] is not recognised (I tried various > other forms but to no avail). I think (my_box[0])[0] would work to get the lower x-coordinate, if that's what you're after. regards, tom lane