In Django data model, Consider that we have a text like this: I am going to go somewhere. If I use the Entity.objects.filter(column__contains="go"), it will return going word as well. But I only want the go word to be returned.…
I have two tables that share IDs on a postgresql . I would like to select certain rows from table A, based on condition Y (in table A) AND based on Condition Z in a different table (B) ). For…
Rails executing update on deleted records. I have a web app on ruby on rails in which I created some users and after that I opened the rails console and assigned U1 to one of my user let say last…
SQL optimization problem, which of the two solutions below is the most efficient? I have the table from the image, I need to group the data by CPF and date and know if the CPFs had at least one login_ok…
reservationLogs = await this.dbContext.ReservationLogs .Where(r => r.ProcessedAt == null) .Where(r => r.PropertyId == validPropertyId) .OrderBy(r => r.CreatedAt).ThenBy(r => r.Operation) .Take(200) .ToListAsync(); some times with the same query i get the error ' Can't cast database type timestamp without time zone to Instant' note: CreatedAt nodaTime instane i am trying to find the exact reason
I need to kill my session, if I'm blocking other sessions.But as of now we have only option to kill own session blocked by other sessions using lock_timeout. Do we have option in postgres to timeout own session, if our…
I have below price audit table in timescale db. When I get new price I should calculate minimum price in last 30 days. But our price data not daily. In every price changes I write date and price to table.…
I'm trying to insert a JSON Array (defined as "_json" in the table structure) to a PostgreSQL table, using a csv. This is the insert statement: INSERT INTO "MySchema".my_table (id, main_array) values(DEFAULT, '{{"KeyA": 10,"KeyB":20},{"KeyA": 100,"KeyB":200}}'); Getting the following error: ERROR:…
I have a table in which one column represent a name of a table in my db. TableA | tableName | ------------- | table 1 | | table 2 | | ....... | | table n | What I need…
I need to return only the JSON from multiple rows where keys are matched. What am I missing? SELECT jsonb_object_agg(key, value) FROM jsonb_each((SELECT data from hit_count_13306823936951630992)) WHERE key IN ('8517', '1099'); ERROR: more than one row returned by a subquery…