Triet Pham trietphm

🍄

1 Up

trietphm / sample-data-for-partial-index.sql

Created August 4, 2019 12:43

Sample data for partial index

	DROP SEQUENCE seq1;
	DROP SEQUENCE seq2;
	DROP TABLE rdata;

	CREATE SEQUENCE seq1;
	CREATE SEQUENCE seq2;
	CREATE TABLE rdata (
	id serial PRIMARY KEY NOT NULL,
	name VARCHAR(255),
	balance FLOAT,

trietphm / init-data.sql

Created August 7, 2019 07:24


	CREATE SEQUENCE seq1;
	CREATE SEQUENCE seq2;
	CREATE TABLE rdata (
	id serial PRIMARY KEY NOT NULL,
	name VARCHAR(255),
	balance FLOAT,
	unique_val1 INTEGER,
	unique_val2 INTEGER,
	registered BOOLEAN,

trietphm / init-window-function.sql

Created August 8, 2019 15:28