I wanted to delete all records except the one with the highest value so I did CREATE TABLE code ( id SERIAL, name VARCHAR(255) NOT NULL , value int NOT NULL ); INSERT INTO code (name,value) VALUES ('name',1); INSERT INTO…
I'm setting up my integration testing rig. I'm using the beforeEach and afterEach hooks to wrap every single test in a transaction that rollsback so that the tests don't affect each other. A simplified example might be this: const {…
I have database that looks like this CREATE TABLE code ( id SERIAL, name VARCHAR(255) NOT NULL ); INSERT INTO code (name) VALUES ('random_value1_random'); INSERT INTO code (name) VALUES ('random_value123_random'); CREATE TABLE value ( id SERIAL, name VARCHAR(255) NOT NULL…
I have a bit of a complicated scenario. I have two tables, employee and agency. An employee may or may not have an agency, but if an employee has an agency I want the select clause to check another condition…
I have 2 tables Customer and Orders. 1st question: That is a master table for Customers that have a few columns like Customer number, customer name, Active flag, etc. Table may contain 2 or more records for the same customer…
I have a table items and a table batches. A batch can have n items associated by items.batch_id. I'd like to write a query item counts in two groups batched and unbatched: items WHERE batch_id IS NOT NULL (batched) items…
We have these tables in PostgreSQL 12: User -> id, name, email items -> id, user_id, description We want to run a query to find users that have 1 item or less. I tried using a join statement and in…
We are working with Symfony and Doctrine ORM. We mostly use MySQL / MariaDB, and for a new project we are considering trying PostgreSQL. Obviously using an ORM like Doctrine is doing a lot of the work for us, and…
I just installed Azure Data Studio (ADS) and PostgreSQL extension. ADS connects to my Postgresql and I can do queries on my database. However, the dropdown 'Databases' tab does not expand. When I right click, to do Refresh, an error…
Scenario: Invoice has many purchase_orders and purchase_orders has many invoices. Intermediate table is npayment_links which has foreign key invoice_id, purchase_order_id. Tech Stack Rails 5.x, Postgresql Here is my sample data invoices id name status 100 sample.pdf archived 101 sample1.pdf archived…