sum( (record_id is NULL AND joined.table_id is NULL)::int ) I know the sum returns the sum of the column entries, but what will this expression (... and...) return, can it be compared with this expression (.. + ..), and what…
I have two tables: TableA Id Status User 1 15 111 2 15 111 3 15 111 And TableB which contains history of status changes from previous table: Id IdA Status Date 1 1 10 2023-01-18 2 1 30 2022-12-18…
Here is my Enum: public enum AdvertStatus { Active, Archived } And my entity type: public record Advertisement { ... public AdvertStatus Status { get; set; } ... } In database it's stored as int, Database is Postgree When I…
I have a script trying to restart postgresql docker container: DOCKER_CONTAINER_NAME="timescaledb" docker restart -t 1 $DOCKER_CONTAINER_NAME timeout 9000000s bash -c "until docker exec $DOCKER_CONTAINER_NAME pg_isready ; do sleep 1 ; done" However, this line (with any -t number) docker restart…
The owner of my schema - public is called 'eyal', and the owner of the tabled inside the schema, called 'postgres'. I am trying to change my table owner (when im logged to user: 'eyal') to user: 'eyal' but i…
I have a question I want to use Templates reference - {{ds}} When substituting in PostgresOperator, everything works out well (I guess so) And PostgresHook does not want to work def prc_mymys_update(procedure: str, type_agg: str): with PostgresHook(postgres_conn_id=CONNECTION_ID_GP).get_conn() as conn: with…
Let's say we have a huge query like this: SELECT id, quality FROM products ORDER BY quality Is it possible to retrieve the N first rows AND the N last rows of the results, without performing two requests ? What…
I have a ledger-like table in a postgresql DB that tracks events for film comparisons on a site where users can add/remove film comparisons. Each event is recorded as a timestamped row in the event database. Rows are never removed:…
Can't come up with easy solution how to union tables with same columns but from second table add only rows which are present in first table. t1: id A B C 1 xx r g 2 cc r g 5…
When running this query: SELECT id,col1,col2 FROM app_data.content_cards I get a table like this: +----+-------------------------------+--------+ | id | col1 | col2 | +----+-------------------------------+--------+ | 90 | {'one', 'two', 'three'} | {1,2,3}| +----+-------------------------------+--------+ | 91 | {'abc', 'def'} | {1,2} |…