Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1EG0Wx51604 for ; Wed, 14 Feb 2001 11:00:32 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f1EG0M913873; Wed, 14 Feb 2001 11:00:22 -0500 (EST) To: Ines.Klimann@liafa.jussieu.fr cc: pgsql-sql@postgresql.org Subject: Re: How to create a type ? In-reply-to: <3A895ED7.B4A06EA1@liafa.jussieu.fr> References: <3A895ED7.B4A06EA1@liafa.jussieu.fr> Comments: In-reply-to Ines Klimann message dated "Tue, 13 Feb 2001 17:20:39 +0100" Date: Wed, 14 Feb 2001 11:00:22 -0500 Message-ID: <13870.982166422@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/261 X-Sequence-Number: 1452 Ines Klimann writes: > 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. Can't do it that way, because SQL functions can't produce or consume the plain C strings that input/output conversion functions have to deal with. There's really no way to write an input or output function except in C. regards, tom lane