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);
parcmicro=# create table toto (mac macad);
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
01 64 47 43 60 à Verrières (lundi,mercredi et vendredi)
01 44 27 47 59 à Jussieu (Mardi et Jeudi)

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to