Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1EDdgx30173 for ; Wed, 14 Feb 2001 08:39:42 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from shiva.jussieu.fr (shiva.jussieu.fr [134.157.0.129]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1DGKjx96540 for ; Tue, 13 Feb 2001 11:20:50 -0500 (EST) (envelope-from Ines.Klimann@liafa.jussieu.fr) Received: from mail.liafa.jussieu.fr (liafa1.liafa.jussieu.fr [132.227.81.128]) by shiva.jussieu.fr (8.10.0/jtpda-5.3.3) with ESMTP id f1DGKdq02641 for ; Tue, 13 Feb 2001 17:20:39 +0100 (CET) Received: from liafa0.liafa.jussieu.fr (liafa0.liafa.jussieu.fr [132.227.81.1]) by mail.liafa.jussieu.fr (8.9.3/jtpda-5.3.2) with ESMTP id RAA30417 for ; Tue, 13 Feb 2001 17:20:39 +0100 (MET) Received: from liafa.jussieu.fr (localhost [127.0.0.1]) by liafa0.liafa.jussieu.fr (8.9.3/jtpda-5.3.2) with ESMTP id RAA12203 for ; Tue, 13 Feb 2001 17:20:39 +0100 Message-ID: <3A895ED7.B4A06EA1@liafa.jussieu.fr> Date: Tue, 13 Feb 2001 17:20:39 +0100 From: Ines Klimann Reply-To: Ines.Klimann@liafa.jussieu.fr X-Mailer: Mozilla 4.76 [fr] (X11; U; Linux 2.2.16-3 i686) X-Accept-Language: fr, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: How to create a type ? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/258 X-Sequence-Number: 1449 Hello, I am trying to understand how works CREATE TYPE, but it seems to be too difficult for me... Can someone help me ? I have tried this : ---------------------------------- create function personne_in(text) returns personne as 'select $1;' language 'sql'; create function personne_out(text) returns text as 'select $1;' language 'sql'; create type personne ( internallength = variable, input = personne_in, output = personne_out ); --------------------------------- but it is full of mistakes. Even a simple example in language 'sql' will help me. Thanks, Ines.