pb when creating user type

From: "abdelkrim" <haj(at)idianet(dot)net>
To: <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: pb when creating user type
Date: 1999-05-03 17:46:04
Message-ID: 000401be958c$d356e540$0601a8c0@kosovo.idianet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

hello
I try to create a type complex, i generate a complex.so and when to insert
one complex into a table i have some problems
please help me

CREATE FUNCTION complex_out(opaque)
RETURNS opaque
AS '/usr/local/pgsql/complex.so'
LANGUAGE 'c';
CREATE

CREATE TYPE complex (
internallength = 16,
input = complex_in,
output = complex_out
);
CREATE

CREATE TABLE test_complex (
a complex,
b complex
);
CREATE

INSERT INTO test_complex VALUES ('(1.0, 2.5)', '(4.2, 3.55 )');
ERROR: Can't find function complex_in in file /usr/local/pgsql/complex.so
ERROR: Can't find function complex_in in file /usr/local/pgsql/complex.so
INSERT INTO test_complex VALUES ('(33.0, 51.4)', '(100.42, 93.55)');
ERROR: Can't find function complex_in in file /usr/local/pgsql/complex.so
ERROR: Can't find function complex_in in file /usr/local/pgsql/complex.so

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message JT Kirkpatrick 1999-05-03 18:03:19 error message
Previous Message Mario Simeone 1999-05-03 16:19:32 Bug reporting...