Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1EIEMx67037 for ; Wed, 14 Feb 2001 13:14:22 -0500 (EST) (envelope-from jliang@tidal.ipinc.com) Received: from localhost (jliang@localhost) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id KAA64577; Wed, 14 Feb 2001 10:14:13 -0800 (PST) (envelope-from jliang@tidal.ipinc.com) Date: Wed, 14 Feb 2001 10:14:13 -0800 (PST) From: Jie Liang To: Ines Klimann cc: pgsql-sql@postgresql.org Subject: Re: How to create a type ? In-Reply-To: <3A895ED7.B4A06EA1@liafa.jussieu.fr> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200102/267 X-Sequence-Number: 1458 hope it helps. e.g. create function foo() returns setof varchar as ' select name from categories ' language 'sql'; db=# select foo() as name; name --------------------------------- recreation business web education questionable sex social society weapons/bombs mature humor pornography tasteless computer hacking nudity drugs lingerie/bikini profanity ....... Jie LIANG St. Bernard Software Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.stbernard.com www.ipinc.com On Tue, 13 Feb 2001, Ines Klimann wrote: > 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. >