[SQL] insert values

[Ines . Klimann]

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 <stdio.h>

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.