a-mckinley

-- Alastair McKinley 2020

begin;

create table testing as
select value,
    type_id,
    created,
    case when row_number() over (partition by type_id,value order by created desc ) = 1
    then true

a-mckinley

-- Alastair McKinley 2020

begin;

create table testing as
select jsonb_build_object('value',value) as data,
    type_id,
    created,
    case when row_number() over (partition by type_id,value order by created desc ) = 1
    then true

a-mckinley

license: bsd-3-clause
border: no
scrolling: no
height: 500

a-mckinley

drop table if exists record;
drop table if exists record_type;
create extension if not exists pgcrypto;

-- attributes of each record type including a parameter used in the indexes
create table record_type (
    id bigint not null primary key,
    index_n_chars integer not null,
    name text unique
);

a-mckinley

license: mit