Re: can anybody help me please

First, you don't need to 'create lang' for C. It is predefined language,
you can just use it.
Second, you need to download postgres source (or get it from CVS) to
write postgres functions in C.
You can get it from here for example;
ftp://ftp.postgresql.org/pub/source/v7.3.3
or look at postgresql.org for instructions on getting the source from CVS:
http://www.postgresql.org/docs/7.3/static/cvs.html

When you get the source code, look into the contrib directory - there is
a whole lot of code there that you can use as examples of creating
postgres functions in C

I hope, it helps...

Dima

rifki wrote:

>Hi, there,
>i need a help in creating new data type in postgresql. I've read the manual, create type, i have try to create the type mentioned in the manual (chapter Extending SQL type). but to no avail.
>At first it was my cygwin installation that doesn't support C as the language using createlang. But my postgresql 7.2.2 on linux Redhat 8, show the same behaviour. They only support plpgsql, pltcl, etc.
>
>i also try to make a c program which only prints something like "Hello World", i include the postgresql.h file as header, i found out that the file isn't anywhere in my computer. My question: where can i get it? Can somebody just tell me where the resource is?
>
>i really appreciate those gurus who would like to help newbie like me.
>
>regards,
>rifki
>++++++++++++++++++++++++++
>+ open mind, open heart, act ! +
>++++++++++++++++++++++++++
>
>-------------------------------------------------------------------------------------------
>This message was sent using DeskNow Lite - Free mail & collaboration server
>http://www.desknow.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>