Select distinct(job_id) from A where condition Select distinct(job_id) from B where condition Select distinct(job_id) from C where condition Here may be 1,2 and 3 have some common jobId What I need is count of all job_id which may not get…
I'm migrating an Oracle PLSQL SP to be compatible with Postgres plpgsql (version PostgreSQL 13.6 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit). The exception block of the PLSQL SP has the below code: exception when others then if CURR1%isopen…
I started learning about prisma and supabase and would like to implement both technologies in my Next.js app. After running npx prisma migrate dev --name init I was faced with the following error: Environment variables loaded from .env Prisma schema…
I have issue with filling up recordset. I stored this query into txt file: DROP TABLE IF EXISTS "temp_invoice_id_amount_1"; CREATE TEMPORARY TABLE "temp_invoice_id_amount_1" AS SELECT ROW_NUMBER() OVER() "RN", c."ID" "CaseID", p."ID" "PackageID", trim(concat(d."LastName", ' ', d."FirstName")) "FullName", c."ContragentCaseID", i."ID" "InvoiceID",…
How to extract grouped data for the week using postgresql. Using sunday as the starting day of the week. The main problem is how to make the week count from Sunday instead of Monday
when I run Django project or any code related to Postgres : Referenced from: '/Users/mahmoudnasser/.local/share/virtualenvs/wyspp_backend-PwdII1PB/lib/python3.8/site-packages/psycopg2/_psycopg.cpython-38-darwin.so' Reason: tried: '/opt/homebrew/opt/postgresql/lib/libpq.5.dylib' (no such file), '/usr/local/lib/libpq.5.dylib' (no such file), '/usr/lib/libpq.5.dylib' (no such file) I tried many solutions online but none of them worked. Note:…
My postgres DB has a Price table where I store price data for a bunch of products. For each Price object I store when it was created (Price.timestamp), and whenever there is a new price for the product, I create…
I'm tryng to use a join function in my SQL request. I have two table : tbl_jsontesting -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | id | data | name | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1 | {"complexProperties":[{"properties":{"key":"Registred","Value":"123456789"}},{"properties":{"key":"Urgency","Value":"Total"}},{"properties":{"key":"ImpactScope","Value":"All"}}]} | Some Text | | 2 | {"complexProperties":[{"properties":{"key":"Registred","Value":"123456788"}},{"properties":{"key":"Urgency","Value":"Total"}},{"properties":{"key":"ImpactScope","Value":"All"}}]} | Some…
Problem with a post_save signal? class Book(models.Model): room = models.ForeignKey(Room, on_delete=models.CASCADE, null=False) library = models.ForeignKey(Library, on_delete=models.CASCADE, null=False) created_at = models.DateTimeField(auto_now_add=True) tracker = FieldTracker() def update_service(sender, instance, **kwargs): main_library = Library.object.get(id=1) if not instance.library == library: for book in instance.book_set.all(): book.delete()…
i want to ask something, so i have a table A that have start_date and end_date column to store the data when there is a failure happened, it look like this rows start_date end_date 1 "2021-08-01 00:04:00" "2021-08-01 02:54:00" 2…