How to create a type ? - Mailing list pgsql-sql

From Ines Klimann
Subject How to create a type ?
Date
Msg-id 3A895ED7.B4A06EA1@liafa.jussieu.fr
Whole thread Raw
Responses Re: How to create a type ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How to create a type ?  (Jie Liang <jliang@ipinc.com>)
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: Dave Wedwick
Date:
Subject: Trigger question
Next
From: Jaros³aw B³¹d
Date:
Subject: Re: binary operators