Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001041

Re: [PHP-DB] create type From: Yasuo Ohgaki (yohgaki <email protected>)
Date: 04/12/01

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 <email protected>> wrote in message
news:01041112542102.01365 <email protected>
>
> 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>
>

-- 
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>