RE: [INTERFACES] error insert

On 10-May-99 Craig Orsinger wrote:
>> CREATE FUNCTION complex_in(opaque)
>> RETURNS complex
>> AS '/usr/local/pgsql/postgresql-6.4.2/src/tutorial/complex.so'
>> LANGUAGE 'c';
>> NOTICE: ProcedureCreate: type 'complex' is not yet defined
>> NOTICE: ProcedureCreate: type 'complex' is not yet defined
>> CREATE
>
> Hmmm. Looks like the 'complex' type needs to be defined first.
> I used a different example as a basis for adding types and functions,
> it returned 'opaque' rather than a new type.

I'd suggest replacing "RETURNS complex" with "RETURNS opaque" and
see how that goes.

>> CREATE FUNCTION complex_out(opaque)
>> RETURNS opaque
>> AS '/usr/local/pgsql/postgresql-6.4.2/src/tutorial/complex.so'
>> LANGUAGE 'c';
>> CREATE
>>
>>
>> CREATE TYPE complex (
>> internallength = 16,
>> input = complex_in,
>> output = complex_out
>> );
>> CREATE
>
> Have you tried putting this CREATE TYPE statement before the
> first CREATE FUNCTION statement?

This will not work, for reasons that should have been obvious -
the input and output functions would not have been CREATE'd yet.

----------------------------------
Date: 10-May-99 Time: 11:55:53

Craig Orsinger (email: <orsingerc(at)epg(dot)lewis(dot)army(dot)mil>)
Logicon RDA
Bldg. 8B28 "Just another megalomaniac with ideas above his
6th & F Streets station. The Universe is full of them."
Ft. Lewis, WA 98433 - The Doctor
----------------------------------