| 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: | Whole Thread | Raw Message | 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
| 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... |