Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001041

[PHP-DB] create type From: Olivier Thauvin (olivier.thauvin <email protected>)
Date: 04/11/01

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 <email protected> 
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 <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>