Sender: owner-postgres95@postgres.Berkeley.EDU
X-Return-Path: andrew_yu
Received: from netcom20.netcom.com (cjs@netcom20.netcom.com [192.100.81.133]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id SAA29300 for <postgres95@postgres.berkeley.edu>; Sat, 11 Nov 1995 18:54:10 -0800
Received: by netcom20.netcom.com (8.6.12/Netcom)
	id SAA10381; Sat, 11 Nov 1995 18:52:49 -0800
From: cjs@netcom.com (cjs)
Message-Id: <199511120252.SAA10381@netcom20.netcom.com>
Subject: varchar's
To: postgres95@postgres.Berkeley.EDU
Date: Sat, 11 Nov 1995 18:52:48 -0800 (PST)
X-Mailer: ELM [version 2.4 PL23]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 649       
Resent-To: postgres95-redist
Resent-Date: Sat, 11 Nov 95 18:54:11 -0800
Resent-From: pglite
Resent-XMts: smtp

Hi. 

Three questions:

1) What is the difference between varchar, bpchar, bytea, and text?

2) What does varchar(80) really mean in Postgres95? How is the max-length
   stored in the system database and enforced?

3) Sometimes you know strings will be < 256 chars long or will most
   likely be a certain length a majority of the time. In time like that, it
   sorta nags you that you have that 4 byte overhead for the standard varlen
   structure. What would have to be done to create a pascal string type? Or
   a static length char type where its length would be infered from the 
   catalogs somehow on a per usage basis?

Curious,
Christopher

===============================================================================
  To unsubscribe from the Postgres95 mailing list, send mail with the subject
  line "DEL" to "postgres95-request@postgres.Berkeley.EDU". 
============  URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres95/  ===========
