class Marriage(BaseModel): users = ArrayField(BigIntegerField) chat_id = BigIntegerField() class Meta: indexes = ( (('users', "chat_id"), True), ) I would like to make a unique index for both user values and chat_id for example: there is already such a row in…
I have a bunch of device_id (roughly 300million), I want to create a full video resolution list ['360p', '480p', '540p', '720p', '1080p']for each device_id like device_id 1 2 device_id video_resolution 1 360p 1 480p 1 540p 1 720p 1 1080p…
I consider a row duplicate when the combination of hash_key and load_date is repeating. I can find such rows using this CTE: with w_duplicated_rows as ( select hash_key, load_date, count(*), --row_number() over (partition by hash_key, load_date order by load_date desc)…
YEAR sales 2021 1000 2022 1500 2023 2000 I want show 3rd column min sales with window function. But year=2022. YEAR sales min 2021 1000 1500 2022 1500 1500 2023 2000 1500 I've tried the following query, but it didn't…
On preparation to the release of Doctrine DBAL 4, I want to migrate the identity column of my autoincrement based tables to "serial" type columns, as described here: Migration to identity columns on PostgreSQL There is a nice script included…
I am interested in the implementation or code of the stddev_pop() function. I understand what it does, I know there is a definition in the documentation, but I am interested in the code itself. I tried to find it in…
I have the following table, containing timeseries data. All datapoints of one "dataset" have the same timestamp and value "const". The following example shows two of these "datasets". +-----------+----------+----------+-------------+ | timestamp | const | name | value | +-----------+----------+----------+-------------+ |…
to_date can convert string into date: select to_date('2024-01-01','YYYY-MM-DD'); to_date ------------ 2024-01-01 (1 row) Let's check the data type: select pg_typeof(to_date('2024-01-01','YYYY-MM-DD')); pg_typeof ----------- date Why can't set an variable as date type? set mydate to_date('2024-01-01','YYYY-MM-DD') select :mydate; ERROR: column "yyyy" does…
so I want to build a intventory Management database. My schema looks like this: Database Schema An Itemclass (screwdriver, hammer, measuring device,...) can have many items (screwdriver1, screwdriver2,...) Everything is fine and working as expected. But now i want to…
I need to insert a specific range of years and months into a table so I can relate some climate data to those dates. Just like the table bellow: year month 1961 1 1961 2 1961 3 1961 ... 1961…