Thread: [GENERAL] SPI_execute_plan and vardata

[GENERAL] SPI_execute_plan and vardata

From

Арсен Арутюнян

Date:

22 June 2017, 22:12:42

Hello

I can't:convert char* to Datum

Datum Values[2];

Values[0]-is integer type
but Values[1] is string type so

Values[0] = SET_4_BYTES(227);

please assist how can i convert som char* string to Datum

Values[1] = CONVERT_STRING_TO DATUM(char *); etc

best
--
Арсен Арутюнян

Re: [GENERAL] SPI_execute_plan and vardata

From

Tom Lane

Date:

23 June 2017, 03:32:53

=?UTF-8?B?0JDRgNGB0LXQvSDQkNGA0YPRgtGO0L3Rj9C9?= <arutar@bk.ru> writes:
> Datum Values[2];

> Values[0]-is integer type 
> but Values[1] is string type so 

> Values[0] = SET_4_BYTES(227);

This is really bad practice.  It might accidentally work, but the
right way to do it is more like

    Values[0] = Int32GetDatum(227);

or possibly Int64GetDatum if you're thinking of bigint rather than int4.

> please assist how can i convert som char* string to Datum

You're not being too clear about which "string type" you have in mind,
but if it's text, good practice would be

    Values[1] = CStringGetTextDatum(char-*-ptr);

            regards, tom lane

[GENERAL] Re[2]: [GENERAL] SPI_execute_plan and vardata

From

Арсен Арутюнян

Date:

23 June 2017, 13:46:33

Thank you

next question - how i can call pg_notify or NOTIFY query from c function

Arsen

Пятница, 23 июня 2017, 0:33 +03:00 от Tom Lane <tgl@sss.pgh.pa.us>:

Арсен Арутюнян <arutar@bk.ru> writes:
> Datum Values[2];

> Values[0]-is integer type
> but Values[1] is string type so

> Values[0] = SET_4_BYTES(227);

This is really bad practice. It might accidentally work, but the
right way to do it is more like

Values[0] = Int32GetDatum(227);

or possibly Int64GetDatum if you're thinking of bigint rather than int4.

> please assist how can i convert som char* string to Datum

You're not being too clear about which "string type" you have in mind,
but if it's text, good practice would be

Values[1] = CStringGetTextDatum(char-*-ptr);

regards, tom lane