Again: [GENERAL] Extending SQL with a C function

From: Christoph Lorenz <ChLorenz(at)csi(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Again: [GENERAL] Extending SQL with a C function
Date: 1998-06-02 08:26:49
Message-ID: uogwcxl86.fsf@haup42174.inhouse.compuserve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)csi(dot)com **
** No Spam ! ** No Adverts ! ** No Junk-Mails ! ** No unwanted Mails ! **

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Lorenz 1998-06-02 08:28:07 Changing column in a table
Previous Message Karl Eichwalder 1998-06-02 08:25:50 Re: [GENERAL] problem compiling under suse 5.1