As stated in my question, I am now configuring my djagno project to connect with postgres. The issue i am facing is that, when making migrations, it shows me the following error: python manage.py makemigrations Traceback (most recent call last):…
From docs https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-DATETIME-INPUT-TIME-STAMPS TIMESTAMP '2004-10-19 10:23:54+02' is a timestamp with time zone Question: Why select pg_typeof(TIMESTAMP '2004-10-19 10:23:54+02'); gives timestamp without time zone? Expecting timestamp with time zone as docs say. Postgres version SELECT version(); shows PostgreSQL 14.14 (Debian 14.14-1.pgdg120+1)…
set timezone = 'Asia/Ho_Chi_Minh'; I set times displayed to GMT+7. select '2021-02-16 09:00' AT TIME ZONE 'Asia/Singapore'; select '2021-02-16 09:00+06' AT TIME ZONE 'Asia/Singapore'; Output 2021-02-16 10:00:00 2021-02-16 11:00:00 Because AT TIME ZONE converts timestamp without time zone to timestamp…
I have a JSONB column with an array of integers and I'd like to migrate it to a native column of array of integers: ALTER TABLE MyTable ALTER COLUMN MyColumn TYPE int[] USING jsonb_array_elements(MyColumn) However, this does not work: set-returning…
I have input data # | column1 | column2 --+---------+--------- 1 | test1 | test2 2 | test3 | test4 3 | test5 | test4 4 | test3 | test2 5 | test5 | test2 6 | test5 | test6…
for a given date I want to get the streak (dates backward in a row where number is above/equals a certain threshold => in the examples always 1000) Examples: date input 2024-11-15 => Result 2 date input 2024-11-14 => Result…
I have 2 tables in Postgres, one is of about 200M records, and the other a few hundreds. I want to get 10 values from the small table and find the corresponding values in the long table. both are indexed.…
I have a table who has a column timestamp which type is text. Most of the rows have timestamp format as 2024-10-13T00:00:00.000Z. But there are some rows have invalid timestamp value. When I use this date_trunc to aggregate the timestamp,…
1.I have a BaseModel class: public class BaseModel : BaseDeletedModel { [Key, Column(Order = 0), MaxLength(50), Required] public string ID { get; set; } } public class BaseDeletedModel { [Column(Order = 100), DefaultValue(false)] public bool IsDeleted { get; set; }…
Any known explanation of this? Why Order By ASC doesn't return any item but order by DESC doesn't? I am using postgres with pg_vector extension SELECT langchain_pg_embedding.document, langchain_pg_embedding.embedding <=> (ARRAY [-0.021213598549366, ..., -0.03685509413480759])::vector AS distance FROM langchain_pg_embedding JOIN langchain_pg_collection ON…