Again: [GENERAL] Extending SQL with a C function - Mailing list pgsql-general

From Christoph Lorenz
Subject Again: [GENERAL] Extending SQL with a C function
Date
Msg-id uogwcxl86.fsf@haup42174.inhouse.compuserve.com
Whole thread Raw
In response to Extending SQL with a C function  (Christoph Lorenz <ChLorenz@csi.com>)
Responses Re: Again: [GENERAL] Extending SQL with a C function  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List pgsql-general
Hi,

I still haven't found it out, so here's my question again:

> how can I write a SQL extention in C, which works with "unusual" data
> types?
>
> I've managed to write a c function, which accepts int4 as input parameter
> and has got int4 as output parameter.
>
> My problem now is, that I want to use a char(10) as input parameter, since
> the input for that function is a colum, which is a char(10) type.
> How do I do this?
>
> (In the manuals, it is said, one should create an own data type in C - I've
> already done this, called it "char10", but of course, I cannot use this
> data type in SQL...)
>
Thank you very much
  Christoph
--
** http://ourworld.compuserve.com/homepages/ChLorenz/ ** ChLorenz@csi.com **
 ** No Spam ! ** No Adverts ! ** No Junk-Mails ! ** No unwanted Mails ! **

pgsql-general by date:

Previous
From: Karl Eichwalder
Date:
Subject: Re: [GENERAL] problem compiling under suse 5.1
Next
From: Christoph Lorenz
Date:
Subject: Changing column in a table