Say i have the following table, called graph: _id relates 1 {2, 3} 2 {4} 3 {5, 6} 4 {3, 7} 5 {} 6 {} 7 {} Here it is in graph form: graph My problem is to write a…
I am trying to use this query in springboot so I can display the results in a webpage. I know that this query works because I tested it in postgresql and it gave me the right results. But JPA is…
I have a query to show the average length of all the proteins which also exists in a second table mrna_pieces: SELECT AVG(protein_length) FROM protein WHERE exists (SELECT protein_id FROM mrna_pieces WHERE mrna_brokstukken.protein_id = protein.protein_id) I also want to show…
I am using BIGSERIAL as a Primary key and I want to make use of the deleted row's ids. Example of the table that I want re-use the deleted ids from the deleted rows: DELETE FROM my_table WHERE id=3; INSERT…
I have a table that has some file input data with file_id and file_input_date. I want to filter / group these file_ids depending on file_input_date. The problem is my date is in format of YYYY-MM-DD HH:mm:ss and I want to…
Does anyone know how I can make a generated column in Postgres? This is the code in SQL Server: CREATE TABLE [dbo].[PRICE] ( [ISIN] [varchar](50) NOT NULL, [Nemo] [varchar](50) NOT NULL, [Month(t)] [int] NOT NULL, [Month(t-1)] [int] NOT NULL, [Month(t-2)]…
I have a table tab1 in timescale db which has 3 columns tag, time, value. time and tag make up the pk for the table: (time, tag). There are more than 500 lakhs (50 000 000) of rows. I need…
As I want to try out Apache Age of postgresql, I got lost when reading the documentation. Is there any easy solutions ?
I have a table "users": drop table users; CREATE TABLE users( id int, user_id int, phone_number VARCHAR(30), email VARCHAR(30)); INSERT INTO users VALUES (1, 999, 61412308310, '[email protected] '), (2, 129, 61477708777, '[email protected] '), (3, 213, 61488908495, '[email protected]'), (4, 145, 61477708777,…
I have a table that looks like this id name count 1 Nishu 4 2 Shivam 2 3 Himanshu 1 I want to get the Output like this:- id name count 1 Nishu 4 1 Nishu 4 1 Nishu 4…