Re: create type

Why you want to create MAC address type? It's already there in V7. macaddr | XX:XX:XX:XX:XX, MAC address Besides, do you have functions defined for INPUT and OUTPUT? You must define them. Refer to PostgreSQL User Manual for details. Regards, -- Yasuo Ohgaki "Olivier Thauvin" <olivier.thauvin@aerov.jussieu.fr> wrote in message news:01041112542102.01365@andromede.aerov.jussieu.fr... > > Is somebody an example of create type under Postgres (v. 7) I have a probleme with the input function of the new type: > > > parcmicro=# CREATE TYPE "macad" ( internallength = variable, externallength = variable, input = macadi, output = macado, PASSEDBYVALUE); > CREATE > parcmicro=# create table toto (mac macad); > CREATE > parcmicro=# insert into toto (mac) values ('AA:AA:AA:AA:AA:AA'); > NOTICE: plpgsql: ERROR during compile of macadi near line 0 > ERROR: cache lookup for return type 0 failed > > > What i'm doing wrong ? Thanks a lot. > > -- > Olivier Thauvin-CNRS Service Aeronomie > olivier.thauvin@aerov.jussieu.fr > Téléphone: > 01 64 47 43 60 à Verrières (lundi,mercredi et vendredi) > 01 44 27 47 59 à Jussieu (Mardi et Jeudi) > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >