[GENERAL] Fwd: lots of errors from fmgr.h when I try to write a C UDF

2014-01-31 Thread Anh Pham
Hi, I had Postgres 9.3 setup and run successfully in Eclipse (MacOSX) I am trying to write a C user-defined function: *#include * *...* *#ifdef PG_MODULE_MAGIC* *PG_MODULE_MAGIC;* *#endif* ... However, when I tried to compile the code: *gcc -fpic -c* ... It gave me a lot of errors and warnings fr

Re: [GENERAL] Fwd: lots of errors from fmgr.h when I try to write a C UDF

2014-01-31 Thread Anh Pham
Hi, I actually included 'postgres.h' However I found out that when I stopped the server, the code then compiled successfully. It's weird On Fri, Jan 31, 2014 at 10:53 PM, Ian Lawrence Barwick wrote: > 2014-02-01 Anh Pham : > > Hi, > > I had Postgres 9.3 setup a

[GENERAL] execute table query in backend

2014-03-03 Thread Anh Pham
Hi, I am trying to extend the server backend by writing a new module. Basically, it tries to retrieve tuples from a specific table using some predefined qualifications (equivalent to "SELECT FROM WHERE" client sql statement ). Is there any quick or efficient way to do this? Many thanks :)

Re: [GENERAL] execute table query in backend

2014-03-10 Thread Anh Pham
issue another scan operation on a different table based on these information On Thu, Mar 6, 2014 at 12:36 AM, Amit Langote wrote: > On Tue, Mar 4, 2014 at 12:38 AM, Anh Pham wrote: > > Hi, > > I am trying to extend the server backend by writing a new module. > > Basically, it tri

[NOVICE][GENERAL] Convert Datum to an user-defined data type?

2014-03-10 Thread Anh Pham
Hi everyone, I have created a new data types using SQL in a database: CREATE TYPE *type1* AS ( score integer, time integer[], ); I also created a server extension module (C code), and I was able to retrieve a Datum value of *type1 *from the database (using SPI_ functions) My question is: how can