Re: Stored procedures in C - Mailing list pgsql-general

From Martin Gainty
Subject Re: Stored procedures in C
Date
Msg-id BLU142-DAV73530EA88AF21C66B5421AEE30@phx.gbl
Whole thread Raw
In response to Stored procedures in C  ("Emiliano Moscato" <moski666@gmail.com>)
Responses Re: Stored procedures in C  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
Emiliano and Mike
 
The real challenge is trying to determine what a datatype is in cobol..for that matter what is stack variable or heap in Cobol?
In the end you're better off <re>writing this mess (preferably in Java)..
unless of course you need the billable hours for
the first rewrite to C
then later rewrite to Java
 
(That should get you at least 2 weeks worth of work..)
 
Buena Suerte/Good Luck
Martin
----- Original Message -----
Sent: Wednesday, April 23, 2008 3:32 PM
Subject: [GENERAL] Stored procedures in C

Hi all,

I have to do some stuff writing stored procedures for Postgres in C. I saw the oficial documentation but it was hard for me to find out how to do a simple function, let's call it "query()" , that receives a string and uses this string to do a query and return the results. Has anyone some examples?
I am looking at crosstab() example at contrib/tablefunc/tablefunc.c, but it is hard to follow, cause it does more complicated stuff.
Thanks in advance...
Regards,

Emiliano
--
mOsKi
"No hay nada que uno haga mal , lo que hay es poco vino." Autor Anonimo

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Need to update all my 60 million rows at once without transactional integrity
Next
From: Tim Tassonis
Date:
Subject: Re: initdb in 8.3