[HACKERS] date_in function

2002-04-17 Thread Dragos Manzateanu
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 = DirectF

Re: [HACKERS] date_in function

2002-04-16 Thread Dragos Manzateanu
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

Re: [HACKERS] date_in function

2002-04-16 Thread Dragos Manzateanu
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

[HACKERS] date_in function

2002-04-16 Thread Dragos Manzateanu
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 = DirectFunc