X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 17B36D1B50A for ; Wed, 29 Oct 2003 04:06:41 +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 33978-08 for ; Wed, 29 Oct 2003 00:06:10 -0400 (AST) Received: from hotmail.com (bay9-f45.bay9.hotmail.com [64.4.47.45]) by svr1.postgresql.org (Postfix) with ESMTP id 228EBD1B523 for ; Wed, 29 Oct 2003 00:06:10 -0400 (AST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 28 Oct 2003 20:06:09 -0800 Received: from 216.114.246.197 by by9fd.bay9.hotmail.msn.com with HTTP; Wed, 29 Oct 2003 04:06:08 GMT X-Originating-IP: [216.114.246.197] X-Originating-Email: [cstotes@hotmail.com] From: "Clint Stotesbery" To: pgsql-sql@postgresql.org Subject: create type input and output function examples Date: Wed, 29 Oct 2003 04:06:08 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 29 Oct 2003 04:06:09.0178 (UTC) FILETIME=[FB9FB7A0:01C39DD1] X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200310/375 X-Sequence-Number: 15775 I've seen the docs for create type and an example of the syntax to create a type. What I haven't seen is the functions that are passed for the input and output elements. CREATE TYPE box (INTERNALLENGTH = 8, INPUT = my_procedure_1, OUTPUT = my_procedure_2); Now what would be in my_procedure1 and my_procedure2 procedures? I know they are just example placeholders above but I need to see a real example of what would be in those procedures to better understand what they should do. Thanks. _________________________________________________________________ Surf and talk on the phone at the same time with broadband Internet access. Get high-speed for as low as $29.95/month (depending on the local service providers in your area). https://broadband.msn.com