I am developing a PostgreSQL Procedure using the plpython3u extension which let you use python procedural language into PostgreSQL. With the following code using plpy, I am able to retrive data form table and put it into pandas dataframe. CREATE…
SELECT wilayah,nilai,t_rkpd,tahun,periode FROM nilai_indikator INNER JOIN provinsi ON nilai_indikator.wilayah=provinsi.id WHERE tahun='2022' AND periode='08' AND id_indikator='6' When i query that code the result is like this table I try count if the nilai is less or greater than t_rkpd, using this…
I have this for query for a table of a size of 2 700 000 rows in Heroku Postgres 12.16: SELECT 1 AS one FROM "users" WHERE ( external_id = 18 AND (email = '[email protected]' OR uuid = '779c7963-67b2-43ea-b19b-028759a146dc')) LIMIT…
I am trying to construct a SQL query that returns all the rows (id's) that have tag: 3 AND tag: 4 - in this case it is the single row for 564800, however I can't seem to figure out how…
I'm having a problem with multi-level whereHas because the restriction / condition of city is not being respected & the query returns all records. I know I'm performing an unnecessary nested whereHas, I know I could simplify the query, yet,…
Let say I have two table with 2 columns : Table A : Job Cost 1 100 1 200 2 100 2 150 2 50 And Table B : Job Sell 1 100 1 100 1 200 2 100 2…
I am trying to get some graph about different entries in a column in Grafana, but Grafana tries to recognize the antry as a column instead of a column value. I have the following setup: A PostgreSQL Database (v11). A…
I want to count some data in a month after a specific date. the table looks like this date user_id tx_id 2022-07-08 123 1 2022-07-08 124 2 2022-07-10 123 3 I want to count every tx_id that user_id number 123…
newbie here. There are station names in a column that have extra characters at the end. I'd like to trim them in PostgreSQL. For example, this works to remove ' (Temp)' at the end. SELECT station_name, RTRIM(station_name,' (Temp)') FROM station_data…
I am trying to build the query to remove duplicate records and retain the latest in postgres. Input : Object_Name,Id,name,insert_date,update_date a,NULL,NULL,2023-08-28, a,NULL,NULL,2023-08-29, b,test,test1,,2023-08-29 a,NULL,NULL,2023-08-30, Output :Need to delete duplicate rows where object name is same and Id and name is…