On Tuesday 16 April 2002 10:32 pm, you wrote: > On Tuesday 16 April 2002 05:48 pm, you wrote: > > 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 ? > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > Not my function is about, but date_in. > Have anybody worked with these ? > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
