date_in function
| От | Dragos Manzateanu |
|---|---|
| Тема | date_in function |
| Дата | |
| Msg-id | 200204170836.g3H8ao219753@mail.dntis.ro обсуждение исходный текст |
| Ответ на | Re: date_in function (Dragos Manzateanu <dragon@mail.dntis.ro>) |
| Ответы |
Re: date_in function
|
| Список | pgsql-hackers |
I want to change the date from a field in a tuple in a trigger_function create table example ( my_date datetime ... ); int na; char select[20]; na = SPI_fnumber(trigdata->tg_relation->rd_att, "my_date"); memset(select, 0, sizeof(select)); sprintf(select, "1/1/2002"); newval = DirectFunctionCall1(date_in, CStringGetDatum(select)); rettuple = SPI_modifytuple(trigdata->tg_relation, rettuple, 1, &na, &newval, NULL); if(rettuple == NULL) elog(ERROR, "my_function: %d returned by SPI_modifytuple", SPI_result); when i test that my server goes down. What I missed ? Not my function is about, but date_in. Have anybody worked with this function ? Can somebody give me a sample to use date_in. Thanks.
В списке pgsql-hackers по дате отправления: