X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8760F3A44E8 for ; Wed, 3 Nov 2004 16:24:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01141-07 for ; Wed, 3 Nov 2004 16:23:55 +0000 (GMT) Received: from dhcp-7-248.ma.lycos.com (waltham-nat.ma.lycos.com [209.202.205.1]) by svr1.postgresql.org (Postfix) with SMTP id 185C53A44B5 for ; Wed, 3 Nov 2004 16:23:54 +0000 (GMT) Received: (qmail 6959 invoked from network); 3 Nov 2004 15:21:12 -0000 Received: from dhcp-7-97.ma.lycos.com (HELO ?10.124.7.97?) (10.124.7.97) by dhcp-7-248.ma.lycos.com with SMTP; 3 Nov 2004 15:21:12 -0000 In-Reply-To: <34544.62.220.101.165.1099497388.squirrel@ce.sharif.edu> References: <34544.62.220.101.165.1099497388.squirrel@ce.sharif.edu> Mime-Version: 1.0 (Apple Message framework v619) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Cc: pgsql-sql@postgresql.org From: Jeff Subject: Re: CREATE TYPE Date: Wed, 3 Nov 2004 11:23:53 -0500 To: "Ameen - Etemady" X-Mailer: Apple Mail (2.619) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/29 X-Sequence-Number: 19348 On Nov 3, 2004, at 10:56 AM, Ameen - Etemady wrote: > > I like to do it like this: > create table mytmp(name myvarchar(10,"en_US")); > you can't unless you modify the parser. It has special cases to support varchar (and numeric) syntax. -- Jeff Trout http://www.jefftrout.com/ http://www.stuarthamm.net/