macros for better conversion from interval to milliseconds

[ajfriend]

create schema if not exists pdx;
create or replace macro pdx.interval_to_ms(x) as extract('epoch' from x::interval)*1000 + mod(extract('milliseconds' from x::interval), 1000);

[ajfriend]

https://discord.com/channels/909674491309850675/921073327009853451/1058153742811279420