I am struggling with a Postgres slow query issue. Fixtures Consider the following fixtures: DROP TABLE IF EXISTS expectation; DROP TABLE IF EXISTS actual; CREATE TABLE expectation ( set_id int NOT NULL, value int NOT NULL ); INSERT INTO expectation…
I need to find supersets within an association table. You can consider bag to be a collection of item records. The relationship between the two is tracked in bag_item. I need to know which bags are supersets of other bags:…
I run into this situation from time to time, where I want to take a list of things and see if any of them exist in another list. If you have a single number, it's simple enough to use a…
I have a table like below: id device_id device_model 1 101 A 1 201 B 1 202 B 2 102 A 2 301 C 3 103 A 3 203 B 3 302 C I want to select group of ids…
I have this simple structure in my database CREATE TABLE species ( _id INTEGER PRIMARY KEY, name TEXT NOT NULL ); CREATE TABLE compatibility ( _id INTEGER PRIMARY KEY, speciesA INTEGER, speciesB INTEGER, compatibility TINYINT NOT NULL ); I want…
I have the following table members: ID hobby 1 Football 1 Tennis 1 Football 2 Cards 2 Painting 3 Tennis 3 Football 4 Cards and i want to select pairs of members only if they have the exact same hobbies…
I have these tables: Project id name version 1 Swam 0.0.1 2 Dinali 0.0.1 3 Dinali 0.0.2 4 BigR 0.0.3 5 Kale 0.0.1 6 Kale 0.0.2 Person id name 1 Jake 2 Skye 3 Kieth 4 Jim 5 Eliz 6…
create table A { id text, val text } create table B { val0 text, val1 text, val2 text } id and val of table A contain each a large, but discrete number of values in an many-to-many relationship. Sample…
I'm having a bit of trouble with getting a select statement to work correctly. I have the following tables: recipe recipe_ingredient pantry recipe1 ingredient1 Ingredient1 recipe1 ingredient2 Ingredient2 recipe2 ingredient3 I want a select statement that returns recipes when the…
For example, I have this table that contains two specific brands - 'Ford' and 'Subaru', which just so happen to be the top earning brands for the Eastern and Western markets respectively. To obtain this info, I make a view:…