File: plproxy_range.sql

package info (click to toggle)
postgresql-plproxy 2.11.0-13
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 564 kB
  • sloc: ansic: 3,476; sql: 1,136; lex: 340; yacc: 171; makefile: 93; sh: 18; awk: 14
file content (34 lines) | stat: -rw-r--r-- 681 bytes parent folder | download | duplicates (7)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

\c test_part0

CREATE TYPE f8range AS RANGE (
        subtype = float8,
        subtype_diff = float8mi
);

create or replace function test_range(in id int, inout frange f8range,
    out irange int4range)
returns record as $$
begin
    irange := '[20,30)';
    return;
end;
$$ language plpgsql;

select * from test_range(0, '(1.5,2.4]');

\c regression

CREATE TYPE f8range AS RANGE (
        subtype = float8,
        subtype_diff = float8mi
);

create or replace function test_range(in _id integer, inout frange f8range, out irange int4range)
returns setof record as $$
    cluster 'testcluster';
    run on _id;
$$ language plproxy;

select * from test_range(0, '(1.5,2.4]');