report generation get_diffreport

[kottatip]

report generation, what am I doing wrong, tell me please....

select get_diffreport(tstzrange(now() - interval '4 hours',now() - interval '2 hours', now() - interval '1 hours', now()));
ERROR: function tstzrange(timestamp with time zone, timestamp with time zone, timestamp with time zone, timestamp with time zone) does not exist
LINE 1: select get_diffreport(tstzrange(now() - interval '4 hours',n...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

[zubkov-andrei]

Hello!

Building a differential report requires two time intervals. Function tstzrange() gets two timestamps as an interval bounds, it can't be called with four arguments. You could use something like this:

select get_diffreport(
    tstzrange(now() - interval '4 hours',now() - interval '2 hours'),
    tstzrange(now() - interval '1 hours', now())
);

[kottatip]

and so it does not work, maybe this is due to the version (3.4)?
postgres=# select get_diffreport(
postgres(# tstzrange(now() - interval '4 hours',now() - interval '2 hours'),
postgres(# tstzrange(now() - interval '1 hours', now())
postgres(# );
ERROR: function get_diffreport(tstzrange, tstzrange) does not exist
LINE 1: select get_diffreport(
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

[zubkov-andrei]

Unfortunately get_diffreport() function in case of time range parameters have no default for server name. You have to specify a server name, which is 'local' if you did not change it. Try this:

select get_diffreport(
    'local',
    tstzrange(now() - interval '4 hours',now() - interval '2 hours'),
    tstzrange(now() - interval '1 hours', now())
);

[kottatip]

yes it works, thank you very much ;-)