Re: Understanding Datum

2011/3/24 Nick Raj <nickrajjain(at)gmail(dot)com>:
> If Datum contains only the value (not having type specific info.), then
> Suppose i want to print the Datum V value (already defined in postgres)
> then printf("%??", V);
>
> Because V is assigned by PG_GETARG_POINTER(1);
> I don't having the information of type Datum.
>
> How to print the value of Datum in postgres?

you have to find a adequate out function and you have to call it. A
out functions transform a binary Datum value to CString value.

#include "executor/spi.h" /* this is what you need to
work with SPI */
#include "utils/lsyscache.h"

PG_MODULE_MAGIC;

extern Datum quote_literal(PG_FUNCTION_ARGS);
PG_FUNCTION_INFO_V1(quote_literal);

Datum
quote_literal(PG_FUNCTION_ARGS)
{
text *result;
Oid valtype = get_fn_expr_argtype(fcinfo->flinfo, 0);
Datum value = PG_GETARG_DATUM(0);
Oid typoutput;
bool typIsVarlena;
StringInfoData buf;

if (!OidIsValid(valtype))
elog(ERROR, "could not determine data type of input");

initStringInfo(&buf);

appendStringInfoChar(&buf, '\'');

getTypeOutputInfo(valtype, &typoutput, &typIsVarlena);
appendStringInfoString(&buf, OidOutputFunctionCall(typoutput, value));

appendStringInfoChar(&buf, '\'');

result = DatumGetTextP(DirectFunctionCall1(textin,
CStringGetDatum(buf.data)));

PG_RETURN_TEXT_P(result);
}

CREATE OR REPLACE FUNCTION quote_literal(anyelement)
RETURNS text
AS 'MODULE_PATHNAME'
LANGUAGE C STRICT;

CREATE OR REPLACE FUNCTION quote_literal(text)
RETURNS text
AS 'MODULE_PATHNAME'
LANGUAGE C STRICT;

Regards

Pavel Stehule

p.s. this is simple variant of this function. For production usage is
using cache necessary.

>
>
> On Thu, Mar 24, 2011 at 2:35 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>
>> Nick Raj <nickrajjain(at)gmail(dot)com> writes:
>> > In postgres, typedef uintptr_t Datum
>> > Datum is getting value from PG_GETARG_POINTER(1);
>> > But, now problem is how would i know the type of PG_GETARG_POINTER(1)
>> > (postgres internally pass this argument) to figure out datum type?
>>
>> Datum does not carry any type information, only a value.  Functions are
>> typically coded to know their input types a priori.  If you want to
>> write code that is not type-specific then you'd better be passing around
>> type OIDs as well as values.
>>
>>                        regards, tom lane
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>