When using the jooq-postgres-extension and inserting a row with a field value IntegerRange.integerRange(10, true, 20, true) in the query it is translated by cast('[10,20]' as int4range). It's interesting that if I run the query select cast('[10,20]' as int4range) I get…
Say I have a query: SELECT column_1, column_2 max(column_3) as max_column_3 FROM table_1 GROUP BY column_1, column_2 and I'm interested in returning the id of each row, instead of just column_1, column_2 max(column_3). When I try: SELECT id, column_1, column_2…
I have a table of this type | id | parent_id | | title | parent_id refers to the id of the same table I need to get a recursive tree for an element knowing only its parent. it will…
t1 (Properties) | Id | Name | | - | ------ | | 31 | Garage | | 32 | Depot | | 33 | Store | t2 (Addresses) | Id | Prop_Id | Primary | | - | -------…
I have this table in PostgreSQL: Table_T: id body 1 bla bla bla Call ID: xxx Interaction ID: vvv bla bla 2 bla bla bla Call ID: zzz Interaction ID: ooo bla bla This is the output I am expecting:…
Suppose I want to keep who follows who in a simple table that has two fields ; UserId and FollowedId and I have a simple data set like ; UserId FollowedId 1 100 2 100 3 100 4 100 5…
I am writing a Flask app with SqlAlchemy and PostgreSQL. When I try to enter a value into an enum field that has more than six characters, I get the following error: sqlalchemy.exc.DataError: (psycopg2.errors.StringDataRightTruncation) value too long for type character…
I'm trying to create the most optimal query where the database would return the names of readers who often borrow sci-fi books. That's what I'm trying to optimize: SELECT reader.name, COUNT (CASE WHEN book.status_id = 1 AND book.category_id = 2…
Table "Observation" is filled with records, that come from table "Result" (observation_id = result_id) In table "Observation" every record has a corresponding record that is also in the same table. Is there a way to link those two records, giving…
Given a database table events with columns: event_id, correlation_id, username, create_timestamp. It contains more than 1M records. There is a problem I am trying to solve: for each event of a particular user display its latest sibling event. Sibling events…