Re: Approved

Please see the attached file.
>From pgsql-sql-owner(at)postgresql(dot)org Sat Jun 7 07:19:17 2003
X-Original-To: pgsql-sql-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (developer.postgresql.org [64.117.224.193])
by svr1.postgresql.org (Postfix) with ESMTP id 91AF3F0001
for <pgsql-sql-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Fri, 6 Jun 2003 22:02:40 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024)
with ESMTP id 05761-03
for <pgsql-sql-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Fri, 6 Jun 2003 22:02:36 +0000 (GMT)
Received: from smtp7.andrew.cmu.edu (SMTP7.andrew.cmu.edu [128.2.10.87])
by svr1.postgresql.org (Postfix) with ESMTP id E6C1EEFFDA
for <pgsql-sql(at)postgresql(dot)org>; Fri, 6 Jun 2003 22:02:35 +0000 (GMT)
Received: from cmu.edu (HANDIN.INTRO.CS.CMU.EDU [128.2.191.145])
by smtp7.andrew.cmu.edu (8.12.9/8.12.3.Beta2) with ESMTP id h56M2ZXi004442
for <pgsql-sql(at)postgresql(dot)org>; Fri, 6 Jun 2003 18:02:36 -0400
Date: Fri, 6 Jun 2003 18:02:35 -0400
Mime-Version: 1.0 (Apple Message framework v552)
Content-Type: text/plain; charset=US-ASCII; format=flowed
Subject: Column limits in table/ views
From: "A.M." <agentm(at)cmu(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Content-Transfer-Encoding: 7bit
Message-Id: <945001F0-986A-11D7-AAB2-0030657192DA(at)cmu(dot)edu>
X-Mailer: Apple Mail (2.552)
X-Archive-Number: 200306/35
X-Sequence-Number: 13793

I have 560 columns of NUMERIC(10,14). To not run up against max column
restraints, I split the information into two tables. Does the column
limit on tables imply the same limit for views or selects or could I
potentially select a row across both tables and make a view that hides
the split?