Received: from shiva.jussieu.fr (shiva.jussieu.fr [134.157.0.129]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1MCqRx39202 for ; Thu, 22 Feb 2001 07:52:27 -0500 (EST) (envelope-from klimann@liafa.jussieu.fr) Received: from mail.liafa.jussieu.fr (liafa1.liafa.jussieu.fr [132.227.81.128]) by shiva.jussieu.fr (8.10.0/jtpda-5.3.3) with ESMTP id f1MCpwf99503 for ; Thu, 22 Feb 2001 13:51:58 +0100 (CET) Received: from liafa0.liafa.jussieu.fr (liafa0.liafa.jussieu.fr [132.227.81.1]) by mail.liafa.jussieu.fr (8.9.3/jtpda-5.3.2) with ESMTP id NAA19690 for ; Thu, 22 Feb 2001 13:52:22 +0100 (MET) From: Ines.Klimann@liafa.jussieu.fr Received: from (klimann@localhost) by liafa0.liafa.jussieu.fr (8.9.3/jtpda-5.3.2) id NAA14892 for pgsql-sql@postgresql.org; Thu, 22 Feb 2001 13:52:22 +0100 Date: Thu, 22 Feb 2001 13:52:22 +0100 To: pgsql-sql@postgresql.org Subject: insert values Message-ID: <20010222135222.A14873@liafa0.liafa.jussieu.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre3us X-Archive-Number: 200102/337 X-Sequence-Number: 1533 Hi, I have the following type : -------------------------------------------- CREATE FUNCTION entier_in(opaque) RETURNS entier AS '/ens/klimann/PostgreSQL/entier.o' LANGUAGE 'c'; CREATE FUNCTION entier_out(opaque) RETURNS opaque AS '/ens/klimann/PostgreSQL/entier.o' LANGUAGE 'c'; CREATE TYPE entier ( internallength = 8, input = entier_in, output = entier_out ); -------------------------------------------- where entier.c is the following program : -------------------------------------------- #include typedef struct entier { long x; } entier; entier * entier_in(char *s) { entier *result; result = (entier *)malloc(sizeof(entier)); result->x = atoi(s); return (result); } char * entier_out(entier *n) { char *result; if (n == NULL) return(NULL); result = (char *) malloc(60); sprintf(result, "%d", n->x); return(result); } ---------------------------------------------- then I create the table entiers as follows : ---------------------------------------------- CREATE TABLE entiers ( val entier ); ---------------------------------------------- How can I insert a value in this table ? I have tried several methods, but I can't find a correct one. Does someone have an idea ? Thanks a lot, Ines.