postgresql Questions

Postgres DATE_TRUNC not behaving as expected – incorrect data showing – Postgresql

February 11, 2023
Alex Flores
2 Answers

I have the following records that were created_at: 2022-11-13 14:24:02.651809 2022-11-13 15:00:43.878400 2022-11-13 16:33:18.710288 2022-11-13 18:22:59.220246 2022-11-13 18:50:59.719803 2022-11-15 20:33:19.099264 2022-11-16 15:42:51.285751 2022-11-16 15:46:28.196001 2022-11-16 16:06:31.873187 2022-11-16 16:47:32.071435 2022-11-16 19:05:38.288788 When I run: SELECT DATE_TRUNC('day', CAST(forms.created_at AS DATE) AT TIME…

VIEW QUESTION

How can I get the max and the min value for a specific timeframe grouped by day from a timeseries data – Postgresql

February 11, 2023
nexty5
3 Answers

I am using DuckDB and want to process some time-series data that has the following format: ┌─────────────────────┬─────────┬─────────┬─────────┬─────────┬────────┬────────────┐ │ Timestamps │ Open │ High │ Low │ Close │ Volume │ CustomDate │ │ timestamp │ double │ double │ double…

VIEW QUESTION

Inserting more row into PostgreSQL database table results in all values in one row

February 11, 2023
Daniel
3 Answers

Noob question. Despite following the official PostgreSQL syntax I cannot insert multiple rows into a table. It always ends up adding all values to the first row. I first created a table like this: create table "DBSTest".Test (column1 varchar, column2…

VIEW QUESTION

Unable to import module AWS Lambda Function – Amazon Web Sevices

February 11, 2023
Alex Dragut
2 Answers

I'm having issues running basically any lambda function on AWS as the Lambda Function tool would not be able to import the module. I tried to import the packages as layers - pretty wrong I think. (https://www.linkedin.com/pulse/add-external-python-libraries-aws-lambda-using-layers-gabe-olokun/) Then I've tried…

VIEW QUESTION

How can optimize the database to reduce time on query? – Postgresql

February 11, 2023
showkey
3 Answers

VIEW QUESTION

SQL insert string from one column into another in select statement – Postgresql

February 10, 2023
slowmotionnovember
2 Answers

I have a SQL table that looks something like this: Date Object_ID Category Direction 0 2011-02-02 0H 1234 JKL/987 A N 1 2011-02-02 0H 4321 BNM/987 A N 2 2011-02-02 0H 5678+ JKL/987 A N 3 2011-02-02 0H 8765 BNM/987…

VIEW QUESTION

Fetch Millions of Records using CopyManager throwing OutOfMemoryError – Postgresql

February 10, 2023
Himanshu Arya
2 Answers

When I tried running my code in tables with rows in thousands, it worked fine but as a performance testing, I tried it with tables having millions of records and then I encountered this issue. I have tried the above…

VIEW QUESTION

Count number of WHERE filters in SQL query using regex – Postgresql

February 10, 2023
Jialer Chew
2 Answers

Update: I've updated the test string to cover a case that I've missed. I'm trying to do count the number of WHERE filters in a query using regex. So the general idea is to count the number of WHERE and…

VIEW QUESTION

Rails conditional order by priority and status – Postgresql

February 9, 2023
Adem Dinarević
2 Answers

I want to order my Order model by priority, so that the ones with priority: true and with status != 'delivered' are on top. The ones with priority: true and status: delivered should be in the table below with all…

VIEW QUESTION

Changing function so that it retrieves an array type argument causes ERROR: FUNCTION DOES NOT EXIST – Postgresql

February 9, 2023
Matheus Farias
3 Answers

I changed a function so that it receives three arguments instead of only two. In the age--1.2.0.sql file, it was set before as: CREATE FUNCTION ag_catalog.create_vlabel(graph_name name, label_name name) RETURNS void LANGUAGE c AS 'MODULE_PATHNAME'; And then I changed to:…

VIEW QUESTION