Día Juliano en PostgreSQL

CREATE OR REPLACE FUNCTION to_julian(f date)
    RETURNS integer AS
$BODY$
BEGIN
    RETURN cast(to_char(f, 'J') as integer);
END;
$BODY$
LANGUAGE 'plpgsql'