C Functions, datatypes

[A Palmblad]

I'm writing a function in C, and am trying to return a row, containing Numeric and array types. I'm building the row with heap_formtuple. I'm havingtrouble creating the numeric and array Datums. If anyone has some examplecode illustrating this, that'd be great.
-Adam

[Karel Zak]

On Mon, May 03, 2004 at 12:48:19PM -0700, A Palmblad wrote:

I'm writing a function in C, and am trying to return a row, containing
Numeric and array types. I'm building the row with heap_formtuple.
I'm having trouble creating the numeric and array Datums. If anyone
has some example code illustrating this, that'd be great. -Adam

I think best examples you can found in the pgsql/src/backend/utils/adt
directory where is almost all PostgreSQL code with datatypes.

Karel

--
Karel Zak <za***@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Karel Zak]

On Mon, May 03, 2004 at 12:48:19PM -0700, A Palmblad wrote:

I'm writing a function in C, and am trying to return a row, containing
Numeric and array types. I'm building the row with heap_formtuple.
I'm having trouble creating the numeric and array Datums. If anyone
has some example code illustrating this, that'd be great. -Adam

I think best examples you can found in the pgsql/src/backend/utils/adt
directory where is almost all PostgreSQL code with datatypes.

Karel

--
Karel Zak <za***@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Joe Conway]

A Palmblad wrote:

I'm writing a function in C, and am trying to return a row,
containing Numeric and array types. I'm building the row with
heap_formtuple. I'm having trouble creating the numeric and array
Datums. If anyone has some example code illustrating this, that'd be
great.

See PL/R for examples:
http://www.joeconway.com/plr/

Specifically:

plr.c:do_compile()
gathering required information for input conversion of return values

pg_conversion.c:get_scalar_datum()
conversion from (char *value) to Datum using the gathered info for
scalar return datums

pg_conversion.c:get_generic_array_datum()
conversion from multiple (char *values) to Datum using the gathered
info for array return datums

HTH,

Joe

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org