X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BB8ABD1D587 for ; Tue, 18 Nov 2003 22:09:53 +0000 (GMT) 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 29661-01 for ; Tue, 18 Nov 2003 18:09:23 -0400 (AST) Received: from main.gmane.org (main.gmane.org [80.91.224.249]) by svr1.postgresql.org (Postfix) with ESMTP id 6C728D1CA5C for ; Tue, 18 Nov 2003 18:09:20 -0400 (AST) Received: from list by main.gmane.org with local (Exim 3.35 #1 (Debian)) id 1AME1t-0005V4-00 for ; Tue, 18 Nov 2003 23:09:01 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org Received: from sea.gmane.org ([80.91.224.252]) by main.gmane.org with esmtp (Exim 3.35 #1 (Debian)) id 1AME1r-0005Uw-00 for ; Tue, 18 Nov 2003 23:08:59 +0100 Received: from news by sea.gmane.org with local (Exim 3.35 #1 (Debian)) id 1AME1r-0005iB-00 for ; Tue, 18 Nov 2003 23:08:59 +0100 From: Paul Ganainm Subject: Arrays - a good idea? Date: Tue, 18 Nov 2003 22:05:00 -0000 Organization: Néant Lines: 31 Message-ID: X-Complaints-To: usenet@sea.gmane.org X-Newsreader: MicroPlanet Gravity v2.50 X-Virus-Scanned: by amavisd-new at postgresql.org X-Amavis-Alert: BAD HEADER Non-encoded 8-bit data (char E9 hex) in message header 'Organization' Organization: N\351ant\n ^ X-Archive-Number: 200311/228 X-Sequence-Number: 16043 Hi all, Even though PostgreSQL supports arrays, is it a good idea to use them? I mean, they a) don't conform to the relational model and b) are not transportable so if one is designing an app, should one use them? When should they not/never be used? What are the criteria for justifying their use? Paul... -- plinehan__AT__yahoo__DOT__com C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro Please do not top-post.