Re[2]: [GENERAL] SPI_execute_plan and vardata

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(at)sss(dot)pgh(dot)pa(dot)us>:
>
>=?UTF-8?B?0JDRgNGB0LXQvSDQkNGA0YPRgtGO0L3Rj9C9?= < arutar(at)bk(dot)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