sql
if new."category" is "rand_category"
  then
    //Do somthing
  else
    //Do somthing else
  end if;

select * from information_schema.key_column_usage
where constraint_catalog=current_catalog 
and position_in_unique_constraint notnull;

rpc

keys

values

sql
create or replace function insert_json(_js json)
returns void
language plpgsql
as $$

begin
  INSERT INTO db_transactions
  SELECT * FROM json_populate_record (NULL::db_transactions, _js);
  
end;
$$;

insert_json({'t_date':now(),'category':'random_category','amount':120,'deb_acc':'acc_1','cred_acc':'acc_2'});

ALTER TABLE props ADD COLUMN textSearch tsvector GENERATED ALWAYS AS (
  setweight(to_tsvector('english', coalesce(name, '')), 'A') ||
  setweight(to_tsvector('english', coalesce(terms,'')), 'B')
) STORED;

CREATE INDEX props_textsearch_idx ON props USING GIN (textSearch);

db error: ERROR: malformed array literal: ""
DETAIL: Array value must start with "{" or dimension information.
   0: sql_migration_connector::validate_migrations
             at migration-engine\connectors\sql-migration-connector\src\lib.rs:271
   1: migration_core::state::DevDiagnostic
             at migration-engine\core\src\state.rs:248

ALTER TABLE props ADD COLUMN "textSearch" tsvector GENERATED ALWAYS AS (
  setweight(to_tsvector('english', coalesce(name, '')), 'A') ||
  setweight(to_tsvector('english', coalesce(terms,'')), 'B')
) STORED;


-- CreateIndex
CREATE INDEX props_textSearch_idx ON props USING GIN ("textSearch");

terms

string[]

string

ALTER TABLE props ADD COLUMN search tsvector GENERATED ALWAYS AS (
  setweight(to_tsvector('english', coalesce(name, '')), 'A') ||
  setweight(to_tsvector('english', coalesce(terms,'')), 'B')
) STORED;


-- CreateIndex
CREATE INDEX searchidx ON props USING GIN (search);

primary key(item_id, user_id)

sql
create table comments (
  comment_id int primary key generated always as identity,
  user_id uuid references auth.users default auth.uid(),
  blog_slug text not null,
  parent_id int references comments,
  body text not null check(length(body) between 1 and 2000),
  created_at timestamptz not null default now()
);
create index on comments (blog_slug);
create index on comments (parent_id);
alter table comments enable row level security;
create policy select_all on comments for select using (true);
create policy insert_own on comments for insert with check (user_id = auth.uid());
create policy update_own on comments for update using (user_id = auth.uid());
create policy delete_own on comments for delete using (user_id = auth.uid());

sql
grant select on comments to anon;
grant
  insert (blog_slug, body, post_id, parent_id),
  update (body),
  delete
on comments to authenticated;