create type
| From: | Olivier Thauvin | Date: | Wed, 11 Apr 2001 10:54:21 +0000 |
| Subject: | create type | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8476@lists.php.net to get a copy of this message | ||
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)