C trigger problem : conversion of CString to Datum
От | Guy Deleeuw |
---|---|
Тема | C trigger problem : conversion of CString to Datum |
Дата | |
Msg-id | 4B7FFA2C.3030001@eurofer.be обсуждение исходный текст |
Ответы |
Re: C trigger problem : conversion of CString to Datum
|
Список | pgsql-admin |
Hello, I cannot convert properly a cstring to a Datum : Here my code : int attColNumber; Datum new_barcode; bool isnull = 0; char barcode[14]; elog(INFO, "gd_trigfunc_before_article_insert() : bar_code = %s", barcode); attColNumber = COL_BARCODE; new_barcode = CStringGetDatum(barcode); workTuple = SPI_modifytuple(trigdata->tg_relation, trigdata->tg_trigtuple, 1, &attColNumber, &new_barcode, &isnull); the result : # INSERT INTO t_articles VALUES (4001, 1, '065', 'White', NULL, 'XS', null); INFO: gd_trigfunc_before_article_insert() : bar_code = 5492850000012 INSERT 0 1 # select * from t_articles WHERE k_id > 2000; k_id | product_id | color_id | color_desc | height | size | bar_code ------+------------+----------+------------+--------+------+-------------- 4001 | 1 | 065 | White | | XS | 492850000012 (1 ligne) Missing the firs digit of the barcode. Thanks in advance for your help Regards Guy
В списке pgsql-admin по дате отправления: