X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A4F1FD9FE7 for ; Sat, 26 Nov 2005 13:18:21 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66142-05 for ; Sat, 26 Nov 2005 17:18:19 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from shu.cs.utk.edu (shu.cs.utk.edu [160.36.56.39]) by svr1.postgresql.org (Postfix) with ESMTP id B928AD6822 for ; Sat, 26 Nov 2005 13:18:18 -0400 (AST) Received: from localhost (shu [127.0.0.1]) by shu.cs.utk.edu (Postfix) with ESMTP id DEEBA13C12 for ; Sat, 26 Nov 2005 12:18:17 -0500 (EST) Received: from shu.cs.utk.edu ([127.0.0.1]) by localhost (shu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00983-04 for ; Sat, 26 Nov 2005 12:18:16 -0500 (EST) Received: from cetus5.cs.utk.edu (cetus5.cs.utk.edu [160.36.56.87]) by shu.cs.utk.edu (Postfix) with ESMTP id B90C413C11 for ; Sat, 26 Nov 2005 12:18:16 -0500 (EST) Received: by cetus5.cs.utk.edu (Postfix, from userid 2805) id 80286BE01; Sat, 26 Nov 2005 12:18:16 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by cetus5.cs.utk.edu (Postfix) with ESMTP id 6F483BDFD for ; Sat, 26 Nov 2005 12:18:16 -0500 (EST) Date: Sat, 26 Nov 2005 12:18:16 -0500 (EST) From: Colton A Smith To: pgsql-sql@postgresql.org Subject: MAX, MIN and arrays Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new with ClamAV and SpamAssasin at cs.utk.edu X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/257 X-Sequence-Number: 23508 Hi: Let's say I have a table with a column of one-dimensional arrays. What exactly is returned when the database is queried for a maximum from that particular column? The array was the greatest average value? Let's say I have a table with a column of two-dimensional arrays. What then? Thanks!