Re: [GENERAL] time to integer

2001-03-06 Thread Soma Interesting
At 02:27 PM 3/6/2001 -0500, you wrote: >date_part('epoch', timestamp) produces a Unix-style seconds count. > > regards, tom lane Ok, thanks I misunderstood the directions and thought I had to use epoch with the timestamp function somehow :) this is my trigger and functi

Fwd: Re: [GENERAL] time to integer

2001-03-06 Thread Soma Interesting
I should have mentioned that NEW.id is set to default to nextval('id_seq'). >this is my trigger and function: > >CREATE FUNCTION oned_member_num() RETURNS OPAQUE AS ' > BEGIN > NEW.member_num := NEW.id + date_part('epoch', timestamp > 'now'); > RETURN ne