I want to update balance from another table, with sum function but im getting this error: null value in column "balance" violates not-null constraint Any suggestion how can i check to not update null values or to change query so…
I have Postgres db. My NodeJs application connects it and runs a job every 30 minutes. In that job it runs a query. I want to check, that query is actually running or not after every 30 minutes. How can…
I have the following table: +------+-----------+-------------+--------------+ | year | team_name | player_name | total_points | +------+-----------+-------------+--------------+ | 1992 | Magic | Shaq | 2000 | +------+-----------+-------------+--------------+ | 1992 | Magic | Steve Kerr | 4000 | +------+-----------+-------------+--------------+ | 1996 |…
I am facing an issue to update the dataset with data type is date in Condition Script: UPDATE blse SET employment = 2066.3 WHERE date = (i am not sure how) AND industry = 'Total Nonfarm' AND state = 'Alabama'…
I have a relation in a database as follows: constituents Symbol [{"weight":0.5, "ticker":"WPM"},{"weight":0.5, "ticker":"AEM"}] GLD [{"weight":0.5, "ticker":"XYZ"},{"weight":0.5, "ticker":"ABC"}] KLE [{"weight":1.0, "ticker":"TSLA"}] TSLA [{"weight":1.0, "ticker":"MSFT"}] MSFT [{"weight":0.4, "ticker":"XYZ"},{"weight":0.6, "ticker":"ABC"}] KLE [{"weight":0.3, "ticker":"BBBY"},{"weight":0.7, "ticker":"GME"}] MEME I want to get the distinct symbols…
I have aggregated column one column in the table as following aggregated table: *-------------------* | territory | users | *-------------------* | worldwide | 20 | | usa | 6 | | germany | 3 | | australia | 2 |…
I want to export csv file to postgresql db using pentago data integration CE. Which data type should i choose both in pentaho and in postgresql to export data correctly? I am using Pentaho CSV file input. Especially I have…
SELECT t.cora_acct_code, t.accountnumber, c.accounttype, t.accountingdate, t.postingamount, t.refer_30, t.control_30, t.control2_30, t.detaildescription FROM ed.gljedetail_v as t LEFT JOIN ed.glcoa_v as c on t.cora_acct_code = c.cora_acct_code AND t.accountnumber = c.accountnumber WHERE t.cora_acct_code = 'BMW-A' AND t.accountingdate <= now() AND t.accountingdate >= now() -…
i'm really struggling on this one : I have some extradata in a postgresql db in which a number matters. Exemple: {"code_partenaire":"welcome","sous_statut_abc":"1","statut_alpha":"blabla"} {"code_partenaire":"code33","sous_statut_def":"1782","statut_alpha":"blablabla"} {"code_partenaire":"222","sous_statut_ghei":"17","statut_alpha":"blablaa"} I would like to extract the character between ","statut_alpha" and its previous ":" Because there is…
I'm trying to query with Postgres a value where my query string (value) has more char than the actual value in the column: | id | firstName| |:---| :--------| | 1 | bee | | 2 | beeWaxer | so…