I have the first three fields of the following table. I want to compute the number of consecutive days an amount was higher than 0 ("days" field). key date amount days 1 2023-01-23 0 0 1 2023-01-22 10 2 1…
Is there a way to join 2 tables with one query to DB in a way when records from one table are put as an array value in a 'new' column in another table? (It's clear how to do it…
I am getting an error on pg.connect not defined. In the Handler module. I am trying to create a table using postgres in fastify. I have and handle routes folder that handles the routes and sends API requests. When I…
I am trying to download PostgreSQL on my PC using but on the downloads page it is showing not supported. And when I access the same page from another machine the download option is available for windows. This is my…
The goal is a custom aggregate function made with CREATE AGGREGATE called string_agg_oxford; it is an aggregate function that works similar to string_agg except it is smart enough to know how many items it is aggregating so that it can…
currently I'm struggeling with PostgreSQL 11, JSONB and database indices. We have a customers table (shortened): create table public.customers ( id uuid not null, created timestamp without time zone, lastmodified timestamp without time zone, data jsonb, primary key (id, mandantid)…
Something like: SELECT * FROM table WHERE something IN ('{"val1","val2"}'::text[]); I tried it with array_to_string(). SELECT * FROM table WHERE something IN (array_to_string('{"val1","val2"}'::text[])); But I guess that makes it to this: SELECT * FROM table WHERE something IN ('val1,val2'); --one…
I'm trying to import a CSV into an existing PostgreSQL table using DBeaver Import Tool and I need to transform a numeric value multiplying it by 100. Someone knows the syntax to be used in the expression? The official documentation…
I can't seem to be able to create migration with simplest sql to create PostgreSQL procedure. Error is: Exception data: Severity: ERROR SqlState: 42601 MessageText: syntax error at end of input Position: 186 File: scan.l Line: 1184 Routine: scanner_yyerror Sql…
I'm pulling from a database which has multiple records for the same id, and I need to pull it all into the same table output: ID Type Value Value2 1 Age 10 1 Height 136 1 Name Jeff 2 Age…