Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id HAA10886 for postgres-redist; Tue, 31 Jan 1995 07:32:17 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199501311532.HAA10886@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from hummer.e-Commerce.Com (hummer.e-commerce.com [198.235.154.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id HAA10876 for ; Tue, 31 Jan 1995 07:32:15 -0800 Received: by hummer.e-Commerce.Com (4.1/SMI-4.1) id AA06231; Tue, 31 Jan 95 10:34:36 EST Received: from viper.e-commerce.com(192.168.42.12) by hummer.e-Commerce.Com via smap (V1.3) id sma006226; Tue Jan 31 10:34:20 1995 Received: by e-Commerce.Com (4.1/SMI-4.1) id AA05559; Tue, 31 Jan 95 10:31:41 EST From: "Steve Martin" Message-Id: <9501311031.ZM5557@viper> Date: Tue, 31 Jan 1995 10:31:40 -0500 X-Mailer: Z-Mail (3.2.0 06sep94) To: postgres@postgres.Berkeley.EDU Subject: Picking field types Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Tue, 31 Jan 95 07:32:17 -0800 Resent-XMts: smtp Can some one offer some advice or point me to some information on the following. I need a field type that is 10 characters, what is the best type to use: 1) a char16 2) text 3) an array of 10 chars 4) define my own type char10 I'm tempted to go with text for everything, are there performance reasons why this would be a bad idea? -- Stephen Martin smartin@e-Commerce.COM e-Commerce, Inc., 1030 Kamato Road, Suite 201 Mississauga, Ontario, Canada L4W 4B6 ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU". If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ============================================================================== URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/