X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (developer.postgresql.org [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id B1649EFF7E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  6 Jun 2003 15:28:32 +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 29544-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  6 Jun 2003 15:28:31 +0000 (GMT)
Received: from SHYMON (nat.dsbratniak.pw.edu.pl [194.29.137.70])
	by svr1.postgresql.org (Postfix) with ESMTP id A1EA7EFF83
	for <pgsql-sql@postgresql.org>; Fri,  6 Jun 2003 15:28:30 +0000 (GMT)
From: <pgman@candle.pha.pa.us>
To: <pgsql-sql@postgresql.org>
Subject: Re: Approved
Date: Fri, 6 Jun 2003 17:37:05 +0200
Importance: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MSMail-Priority: Normal
X-Priority: 3 (Normal)
MIME-Version: 1.0
Message-Id: <20030606152830.A1EA7EFF83@svr1.postgresql.org>
X-Spam-Status: No, hits=4.8 tagged_above=0.0 required=5.0
	tests=FORGED_MUA_OUTLOOK, MISSING_MIMEOLE, NO_REAL_NAME
X-Spam-Level: *****
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset="iso-8859-1"
X-Archive-Number: 200306/34
X-Sequence-Number: 13792

Please see the attached file.
From pgsql-sql-owner@postgresql.org  Sat Jun  7 07:19:17 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (developer.postgresql.org [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 91AF3F0001
	for <pgsql-sql-postgresql.org@localhost.postgresql.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.org@localhost.postgresql.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@postgresql.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@postgresql.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@cmu.edu>
To: pgsql-sql@postgresql.org
Content-Transfer-Encoding: 7bit
Message-Id: <945001F0-986A-11D7-AAB2-0030657192DA@cmu.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?