Suppose the following: create schema bv; create table bv.user(id bigint primary key); create table bv.user_photo ( id bigint primary key, url varchar(255) not null, user_id bigint references bv.user(id) ); insert into bv.user values (100), (101); insert into bv.user_photo values (1,…
I have table with data: create table measure_app_scalemeasurement ( store_code text, certificate_id text, audit_ending date); insert into measure_app_scalemeasurement values ('K010','vwv', '10.12.2023'), ('K010','cert1','12.12.2023'), ('K054','vwv', '14.12.2023'), ('K054','cert1','20.01.2024'); I want to select min audit_ending date for each market store_code, also getting its corresponding…
In a Postgres db, I have a view called school_id_cards. The view captures a list of id cards per school and student in a school system. ID cards are periodically reissued to students, so there may be any number of…
I am writing a chat app and want to get a list of recent contacts to show in the sidebar. My table has the standard chat fields (sender, receiver, msg, date). I'm currently getting a list of recent contacts by…
I have a table named assets: create table assets ( id bigint primary key, name varchar(255) not null, value double precision not null, business_time timestamp with time zone, insert_time timestamp with time zone default now() not null ); I am…
I have a table named assets. Here is the ddl: create table assets ( id bigint primary key, name varchar(255) not null, value double precision not null, business_time timestamp with time zone, insert_time timestamp with time zone default now() not…
Let's say I have the following PostgreSQL table called products which has millions of records: CREATE TABLE IF NOT EXISTS mytable ( id serial NOT NULL PRIMARY KEY, label VARCHAR(50) NOT NULL, info jsonb NOT NULL, created_at timestamp NOT NULL…