1 CREATE PROCEDURAL LANGUAGE plpgsql;
4 CREATE FUNCTION SEC_TO_TIME(timestamp with time zone)
5 RETURNS timestamp with time zone AS $$
6 select date_trunc('second', $1);
9 CREATE FUNCTION SEC_TO_TIME(bigint)
10 RETURNS interval AS $$
11 select date_trunc('second', $1 * interval '1 second');
14 CREATE FUNCTION UNIX_TIMESTAMP(timestamp with time zone)
15 RETURNS double precision AS $$
16 select date_part('epoch', $1);
19 CREATE FUNCTION SEC_TO_INT(interval)
20 RETURNS double precision AS $$
21 select extract(epoch from $1);
24 CREATE OR REPLACE FUNCTION base64_decode_lstat(int4, varchar) RETURNS int8 AS $$
31 size := split_part($2, ' ', $1);
32 b64 := 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/';
34 FOR i IN 1..length(size) LOOP
35 val := val + (strpos(b64, substr(size, i, 1))-1) * (64^(length(size)-i));
39 $$ language 'plpgsql';