Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 550492E3494 for ; Sun, 10 Feb 2008 22:48:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 34691-03 for ; Sun, 10 Feb 2008 22:48:24 -0400 (AST) Received: from mail.mailpen.net (mail.mailpen.net [209.90.228.14]) by postgresql.org (Postfix) with ESMTP id F3DE92E020D for ; Sun, 10 Feb 2008 21:37:30 -0400 (AST) Received: from [172.24.2.1] (pool-71-113-24-134.sttlwa.dsl-w.verizon.net [71.113.24.134]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.mailpen.net (Postfix) with ESMTP id 3B2A62FE802 for ; Sun, 10 Feb 2008 17:37:28 -0800 (PST) Message-ID: <47AFA703.5060907@ultimeth.com> Date: Sun, 10 Feb 2008 17:38:11 -0800 From: "Dean Gibson (DB Administrator)" Organization: UltiMeth Systems User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Can CREATE TYPE be used to create a synonym? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/67 X-Sequence-Number: 30158 Eg: CREATE TYPE DATETIME AS (dummy TIMESTAMP); I suspect not (syntax issues w/ input, output, etc). Is there an alternate way to declare a type synonym? -- Dean