I want to use fuzzy dates for sorting a Django query, so you can use a full date if you have it, but maybe you only know year and month or maybe you only know year or even decade. For example, Jan XX 2024 would come before Jan 1 2024 and Jan 2 2024. I was originally planning to store as a string 202401XX, 20240101, etc, but Postgres naturally sorts characters after numbers so this would put the date with no day AFTER the date with day specified.

I want to use fuzzy dates for sorting a Django query, so you can use a full date if you have it, but maybe you only know year and month or maybe you only know year or even decade. For example, Jan XX 2024 would come before Jan 1 2024 and Jan 2 2024. I was originally planning to store as a string 202401XX, 20240101, etc, but Postgres naturally sorts characters after numbers so this would put the date with no day AFTER the date with day specified.

In Django I have folder with fixturesgoodscategories.js and fixturesgoodsproducts.js. I installed PostgreSQL and I have tables categories and products. But when I write python manage.py loaddata fixtures/goods/categories.json I get the error: CommandError: No fixture named 'categories' found.

Closed 2 hours ago.

Closed 19 secs ago.

Closed 19 secs ago.

Closed 19 secs ago.

Closed 19 secs ago.

Closed 9 hours ago.

In postgresql, I am able to combine two columns into one into an array like so