I have the following two tables: CREATE TABLE products ( id INT, created_at DATE, sold_at DATE ); CREATE TABLE product_prices ( id INT, product_id INT, price numeric, created_at DATE ); The data model logic works as follows: When a new…
In Postgresql, suppose I have a 2-col table containing 3 records, namely tA id | col_A | col_B | type 1 | 1 | 2 | A 2 | 3 | 4 | B 3 | 3 | 1 |…
I'm trying to select this hierarchical JSON as a table in PostgreSQL The JSON script: '{"NODES":[{"DESC_D":"fam","SEQ":"1","ID":"2304500","NODES":[{"DESC_D":"test 1","SEQ":"2.1","ID":"5214","NODES":[{"DESC_D":"test 1.1","SEQ":"3.1","ID":"999"}]},{"DESC_D":"test 2","SEQ":"2.2","ID":"74542"}]}]}' The output I'm trying to get (click this link) This is a solution a friend wrote. It does the required but…
I am trying to filter rows from my Postgres database with below query. Everything works fine but when I try to check if latesttask column is null or has some value then it shows error: error: column "latesttask" does not…
I'm making a database in PostgreSQL that involves around democracy. All data that should be displayed are controlled by the users, and their percentage of power. I'm struggling to write this SQL query where a collection of tags on a…
I'm working on a SQL database, and I have the following table: Workout Routine id serial PRIMARY KEY, user_id integer REFERENCES users (id) ON DELETE CASCADE NOT NULL, name varchar(255) NOT NULL, active boolean DEFAULT TRUE, UNIQUE(user_id, name) Currently, the…
I'm using Spring boot, and I Run this model. package com.example.demo.Models; import jakarta.persistence.*; @Entity @Table(name = "user") public class UserModel { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(unique = true, nullable = true) private Long id; private String name; private String email;…
I created the stored procedure with this code CREATE PROCEDURE get_conferences_for_attendee ( IN start_time TIMESTAMP, IN end_time TIMESTAMP, IN email VARCHAR(255), IN deleted BOOLEAN ) AS $$ SELECT c.localuuid, c.title, i.id, i.start_time, i.end_time, i.status, a.email, a.deleted FROM Conference c INNER…
I'm using Prisma w/ Postgres and am trying to have a simple 1-to-many relationship with a User which can have zero or more Product(s). I'm able to create 1 product for a particular user but when I try to create…
I am pretty new to golang and gorm so, probably, this is an old question: I have a table in postgresql named datetime with type timestamp I am trying to retrieve it using gorm in a golang project with this…