X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C15CAD1D64C for ; Sat, 6 Mar 2004 05:53:54 +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 89756-03 for ; Sat, 6 Mar 2004 01:53:57 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id B957BD1D606 for ; Sat, 6 Mar 2004 01:53:52 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i265rnws014336; Sat, 6 Mar 2004 00:53:49 -0500 (EST) To: Mike Nolan Cc: chriskl@familyhealth.com.au (Christopher Kings-Lynne), pg@rbt.ca (Rod Taylor), josh@agliodbs.com (Josh Berkus), wmoran@potentialtech.com (Bill Moran), threshar@torgo.978.org (Jeff), pgsql-performance@postgresql.org (Postgresql Performance) Subject: Re: Fixed width rows faster? In-reply-to: <200403060432.i264WFCk025069@gw.tssi.com> References: <200403060432.i264WFCk025069@gw.tssi.com> Comments: In-reply-to Mike Nolan message dated "Fri, 05 Mar 2004 22:32:14 -0600" Date: Sat, 06 Mar 2004 00:53:49 -0500 Message-ID: <14335.1078552429@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/70 X-Sequence-Number: 5926 Mike Nolan writes: >> Can't you just create a TEXT(255) field same as you can just create >> VARCHAR (with no length) field? I think they're basically synonyms for >> each other these days. > I'll defer to the SQL standard gurus on this, as well as to the internals > guys, but I suspect there is a difference between the standard itself > and implementor details, such as how char, varchar, varchar2 and text > are implemented. As long as things work as specified, I don't think > the standard cares much about what's happening behind the curtain. TEXT is not a standard datatype at all; that is, you will not find it in the standard, even though quite a few DBMSes have a datatype that they call by that name. Postgres' interpretation of TEXT is that there is no length-limitation option. I don't know what other DBMSes do with their versions of TEXT. regards, tom lane