iframe-proxy | Sunbelt Computer Software

48 lines (46 loc) · 1.13 KB

-- create on perf_tests database
create function perf_test(
    _records int,
    _text_param text,
    _int_param int,
    _ts_param timestamp,
    _bool_param bool
returns table(
    id1 int, 
    foo1 text, 
    bar1 text, 
    datetime1 timestamp, 
    id2 int, 
    foo2 text, 
    bar2 text, 
    datetime2 timestamp,
    long_foo_bar text, 
    is_foobar bool
language sql
    i + _int_param as id1, 
    'foo' || '_' || _text_param || '_' || i::text as foo1, 
    'bar' || i::text as bar1, 
    (_ts_param::date) + (i::text || ' days')::interval as datetime1, 
    i+1 + _int_param as id2, 
    'foo' || '_' || _text_param || '_' || (i+1)::text as foo2, 
    'bar' || '_' || _text_param || '_' || (i+1)::text as bar2, 
    (_ts_param::date) + ((i+1)::text || ' days')::interval as datetime2,
    'long_foo_bar_' || '_' || _text_param || '_' || (i+2)::text as long_foo_bar, 
    (i % 2)::boolean and _bool_param as is_foobar
    generate_series(1, _records) as i
select * from perf_test(
    _records => 10,
    _text_param => 'abcxyz',
    _int_param => 999,
    _ts_param => '2024-01-01',
    _bool_param => true

Sunbelt Computer Software

PL/B Language Development and Support

Navigation Menu

Uh oh!

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

Uh oh!

FilesExpand file tree

test_function.sql

Latest commit

History

test_function.sql

File metadata and controls