I have a transaction table, I want to get the product ID of the record which is ranked 3rd highest for sales. Please note there there can be multiple transactions for an item and one transaction can have multiple qty.…
I have a table containing data that has a column named id that looks like below: id value 1 value 2 value 3 1 244 550 1000 1 251 551 700 1 540 60 1200 ... ... ... ... 2…
I have the following SQL: SELECT id, user_id, coordinates FROM fields WHERE id IN (SELECT field_id FROM transactions WHERE id IN (11,10,12)) There are 2 tables: transactions and fields. Both of them have their own id field. However, in transactions…
I'm super rusty with databases and haven't got the chance to work too much with them in the past 6-8 years, so there are some things that are uncertain for me. Let's assume I have a simple bi-directional one-to-many situation:…
I want to add a new column that is NULL for existing rows, but has default value for new rows. This: ALTER TABLE foo ADD COLUMN bar timestamp NULL DEFAULT clock_timestamp(); Won't work, because it would add default value to…
In my struct, i have the following type Task struct { gorm.Model Id int `json:"id" gorm:"primaryKey;AUTO_INCREMENT"` UserId int `json:"user_id" gorm:"Index;not null" validate:"required"` TaskId int `json:"task_id" gorm:"Index;not null" validate:"required"` JobId int `json:"job_id" gorm:"not null" validate:"required"` Latitude float64 `json:"latitude" gorm:"not null" validate:"required"`…
I have been trying to select all records from a certain table within my PostgreSQL database using a simple regex. The table in question is a table of inventory items, and each item has a partno. There are a couple…
There are 2 tables, main_table and other_table. A user is allowed access to main_table items if his user_id matches the main_table.user_id column or if there is an entry in other_table where his user_id is in the read_acl column (array using…
I'm trying to update rows in a single table by splitting them into two "sets" of rows. The top part of the set should have a status set to X and the bottom one should have a status set to…
Within our company we've the wish to connect to an AWS RDS postgres database based on a generated IAM token. Mostly, we use DBeaver to connect to databases. However, with DBeaver a .pgpass is necessary to make the connection. My…