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 <t...@sss.pgh.pa.us>: > >=?UTF-8?B?0JDRgNGB0LXQvSDQkNGA0YPRgtGO0L3Rj9C9?= < aru...@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
