I am trying to filter out data that is stored as strings but represents numeric values. I filter out non-numeric strings then convert to a float. I am then trying to filter values above or below a specific amount. Below…
I want get characters between [] from a string example: "hello" and "world" from "gegerferf[hello] frfer [world] frfre rfrf" into a table i am try with substring and for loop but i dont now. select regexp_replace(string, '...','', 'g') from mytable
I use PostgreSQL I can run a single query per day, but it will take a long time to go through every day. The "zone" and "reader" also changes, so to run single queries every time will keep me up…
I have a problem with doing a subquery in PostgreSQL to get a calculated column value, it reports: [21000] ERROR: more than one row returned by a subquery used as an expression Situation I have two tables: accounts postal_code_to_state Accounts…
I have a table with all the users activities and another table with all the users login events. Each of them has a datatime field (creation). I need to count for a specific user with one query how many activities…