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
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