Re: writing custom data type

Arthur Chan <achan@comprehend.com> writes:
> I've been having trouble writing my own custom datatype for PG. when I do
> my `CREATE FUNCTION` call, it fails with:

> resultsets=# CREATE FUNCTION fuzzytime_in(cstring)
>        RETURNS fuzzytime
>        AS 'fuzzytimetype'
>        LANGUAGE C IMMUTABLE STRICT;
> NOTICE:  return type fuzzytime is only a shell
> ERROR:  could not find function "fuzzytime_in" in file
> "/usr/lib/postgresql/9.1/lib/fuzzytimetype.so"

> now I checked my shared lib, and surely enough, it's there

> $ objdump -t /usr/lib/postgresql/9.1/lib/fuzzytimetype.so
> ...
> 00000000000018b0 g     F .text 0000000000000070              fuzzytime_in
> ...