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

2017-06-28 Thread Арсен Арутюнян
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 : > >=?UTF-8?B?0JDRgNGB0LXQvSDQkNGA0YPRgtGO0L3Rj9C9?= < aru...@bk.ru > writes: >> Datum Values[2]; > >> Values[0]-is integer type  >> but Values[1] is string

Re: [GENERAL] SPI_execute_plan and vardata

2017-06-22 Thread Tom Lane
=?UTF-8?B?0JDRgNGB0LXQvSDQkNGA0YPRgtGO0L3Rj9C9?= 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] = Int3

[GENERAL] SPI_execute_plan and vardata

2017-06-22 Thread Арсен Арутюнян
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 -- Арсен Арутюнян