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 function:
CREATE FUNCTION oned_member_num() RETURNS OPAQUE AS '
BEGIN
NEW.member_num := NEW.id + date_part('epoch', timestamp
'now');
RETURN new;
END;'
LANGUAGE 'plpgsql';
CREATE TRIGGER oned_member_num
BEFORE INSERT
ON members
FOR EACH ROW
EXECUTE PROCEDURE oned_member_num();
I'm not 100% sure that a pl/pgsql function is the best/only solution here.
Is it overkill, or my only option?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
