I have 2 tables on my db: 1- scheduled services 2- services realized. On 2nd table, I have the value $ received for the service and the date the service was realized. On 1st table, I only have the scheduled…
The table statuses has 3 columns id (uuid, PK) time (timestamp with time zone, NOT NULL) duration (integer, NOT NULL) The records it contains are not evenly distributed; there could be a single record in a day or thousands in…
I'm using postgresql 15. i have a table called calls with columns the_time timestamptz, a_number text, a_prefix text, b_number text and b_prefix text. I get bulk data as csv and i insert it directly to the db. the data doesn't…
Suppose we have two columns: id, params. params is a jsonb column that contains arrays of objects like: [ { "prop": "a", "answer": "123" }, { "prop": "b", "answer": "456" } ] I need to create a query that returns…
The rough layout I have for some complex queries follows this table structure in Postgres: CREATE TABLE primari ( id BIGINT NOT NULL PRIMARY KEY, name TEXT NOT NULL ); CREATE TABLE secondary ( primary_id BIGINT NOT NULL references primari…
I've been reading up on PostgreSQL transaction isolation and how that relates to Django's transaction.atomic() (e.g. this article, PostgreSQL docs), but I'm far from fluent in this topic and I'm not sure I understand what I've read. We've got a…
I was wondering if I could utilize SPI to access the server and perform a query to return an agtype value. I wanted to implement a function that uses an already created one but then perform an ORDER BY and…
I am trying to query a view, which has an "Operator" column. Sample data: Ed Edward Ed;Adam [null] Bob; Edward Bob; Ed; Tom Given a user input of a List<string>, let's say "Ed","Peter", "Mark", I want to return rows that…
I have a device_events table in which I get signals from various devices. These events could be online offline events for a device. Basically I want all the offline and online events for a device to be paired. We can…
I copy data from postgre db to azure sql with copy activity and auto-create table feature enabled. there is a column with type timestamptz in Source db. looks like 2023-07-03T07:00:47.707369+00:00 2023-07-03T07:00:52.375166+00:00 when I auto-create table in Azure SQL it always…