From: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
---|---|
To: | Christoph Lorenz <ChLorenz(at)csi(dot)com> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: Again: [GENERAL] Extending SQL with a C function |
Date: | 1998-06-02 08:50:17 |
Message-ID: | l03110702b1996cc4d390@[147.233.159.109] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
At 11:26 +0300 on 2/6/98, Christoph Lorenz wrote:
> > 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...)
char(10) is not, in fact, an "unusual" datatype. It's what postgres calls
"bpchar" (blank-padded char). I think there is an interface for dealing
with bpchar fields, which carry their own maximum length which you have to
decode before using.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
From | Date | Subject | |
---|---|---|---|
Next Message | Christian Steindl | 1998-06-02 10:30:32 | ODBC-drv for WinNT 4.0 |
Previous Message | Christoph Lorenz | 1998-06-02 08:28:07 | Changing column in a table |