I've created a table CREATE TABLE test_table ( id VARCHAR(36) PRIMARY KEY, text_arr VARCHAR[][] NOT NULL ) and an entity @AllArgsConstructor @NoArgsConstructor @Getter @Entity @Table(name = "test_table") public class TestTable { @Id private String id; private String[][] text_arr; } also…
For the example table acts below: id request_id 1 234 2 531 and the query below: select request_id, id from acts where id in (234,531,876) I need to get the following result: request_id id 234 1 531 2 876 null…
I need to calculate the (quarterly sessions conversion rate) = (number of orders) / (number of sessions) for an online store. Here is the data table: CREATE TABLE orders_full ( order_id, sessions_id, created_time ) CREATE TABLE sessions_data ( -- records…
I select data from temporary table: CREATE TEMPORARY TABLE IF NOT EXISTS "tmp" ( "fuel_type" TEXT, "litres" NUMERIC(8,2), "is_rent" BOOLEAN ); insert into tmp values ('petrol', 10, False); insert into tmp values ('petrol', 20, False); insert into tmp values ('diesel',…
I have a postgreSQL table that contains the following: select * from ci_grp; ci | grp ------------+------------------------------------------------------------------------------------------- Ci1 | [{"Name":"TEAM.Virtu"},{"Name":"TECH.LinuxDevice"}] Ci2 | [{"Name":"TECH.LinuxDevice"},{"Name":"TEAM.Monitoring"}] Ci3 | [{"Name":"TEAM.Noc"},{"Name":"TEAM.Virtu"},{"Name":"TECH.DellEsx"},{"Name":"TECH.SNMP"}] Ci4 | [{"Name":"TEAM.Monitoring"},{"Name":"TECH.Postgresql"}] Ci5 | [{"Name":"TEAM.Monitoring"},{"Name":"TECH.LinuxDevice"},{"Name":"TECH.ZabbixProxy"}] I need to get a reply that would…
I'm working on an express.js project, using Sequelize as the orm, and postgres as the engine. I'm working on improving the performance of a slow select query that does many things, and one of them is comparing the acronym of…
I have a query where I need to add a positional argument into a call to max(expression). SELECT max(my_real_column) FROM my_table I've tried the concatenation operator, e.g. my_real_column || $1, but that yields an operator error: SELECT max(my_real_column || $1)…
Let's say I have two tables (from uploaded csv files) and I want to do a diff based on an id+territory in the new file that wasn't in the old file. The easiest way to do this is something like:…
I have a database with the following structure table_a | id | username | | -------- | -------- | | 1 | 'a.a' | | 2 | 'a.a' | table_b | id | table_a_id | | -------- | ---------- |…
Just to give a little background on the project; I'm making a Spring Boot project using Maven. I have a two microservices, one called "products" and one called "config-server" to configure the different microservices. I already have a database called…