PostgreSQL Invalid Syntax
I have this in the where clause of my SQL query: '2023/10/21 14:46:32.805068000' + interval '1 second' This causes me to have an "invalid input syntax for type interval" error. Does anyone have a suggestion?
Ubuntu – I keep getting YAML syntax error occurred while parsing /rails/config/database.yml
I really need some help. I am new to Ruby on Rails. I am building a rails 7.1.0 app using postresql with docker. I am working on a Pop!_OS 22.04 LTS computer with ruby 3.2.2 (2023-03-30 revision e51014f9c0) [x86_64-linux] and…
Postgresql – Add a column whose value depends on another row's value
I'm trying to implement an "auto-fail" kind of column in a table that includes scores for evaluations like below: Employee Category Score John Foo 5 John Bar 4 Randy Foo 3 Randy Bar 0 Daniel Foo 2 Daniel Bar 1…
How to cast String to Int using PHP with PostgreSQL
I am working with an api written in php, that is getting data from a postgres database. one of the fields of data is however getting returned by the query as lexicographic sorted. I thus want to try casting it…
Postgresql – Does the column return matter in a WHERE EXISTS subquery?
In this SQL EXISTS operator tutorial has the following syntax for SELECT column_name(s) FROM table_name WHERE EXISTS (SELECT column_name FROM table_name WHERE condition); Does the column_name in the select statement of the subquery matter? From other answers it seems like…
Postgresql – Use SQL to get session duration between two events
I've got a dataset (in postgres specifically) that I need to calculate the 'user session time' for. I'm fairly positive I need to use partitioning to answer the question, but I'm not really sure how to go about it. The…
Postgresql – SQL group three columns from three tables into one column
I have three tables x, y, z that have similar columns like this and the other columns are different: table x: id user_id month year total_price 1 1 January 2023 100.00 2 1 February 2023 200.00 table y: id user_id…
Postgresql – Copy CSV File into Temporary Table
I have a temporary table with 4 columns CREATE TEMP TABLE tmp_import ( a varchar(128), b varchar, c varchar(256), d integer default null ) ON COMMIT DROP I would like to copy data from a csv file into this temp…
Postgresql – Jooq converter from Postgres array to scala list
I have a scala case class case class MyRecord( id: String, dimensions: List[String], // postgres text[] dimensionCodes: List[Long] // postgres integer[] ) and a Jooq query JooqBuilder .default(conn) .select( field("id", classOf[String]), field("dimensions", classOf[List[String]]), field("dimensionCodes", classOf[List[Long]]), ) .from(table(MY_TABLE)) .fetchInto(classOf[MyRecord]) .asScala .toList…
Self join inside table by multiple values. SQL, Postgresql
Please help with self join inside one table by different fields. given table "Items": Used PostgreSQL. I need to get all the values from such table, for which factId = 'urn:fact:drug:170' and factId1 ='urn:fact:drug:171' and factId1.value ='false' and arrayIndexes are…