Using GeneratedField with Postgres

felixxm · January 20, 2024, 6:55pm

You can copy the new implementation of Concat() and ConcatPair() into your code, and use it instead of builtin version:

github.com

django/django/blob/4879907223d70ee1a82474d9286ccfa5dae96971/django/db/models/functions/text.py#L68-L148


      
          class ConcatPair(Func):
              """
              Concatenate two arguments together. This is used by `Concat` because not
              all backend databases support more than two arguments.
              """
          
              function = "CONCAT"
          
              def pipes_concat_sql(self, compiler, connection, **extra_context):
                  coalesced = self.coalesce()
                  return super(ConcatPair, coalesced).as_sql(
                      compiler,
                      connection,
                      template="%(expressions)s",
                      arg_joiner=" || ",
                      **extra_context,
                  )
          
              as_sqlite = pipes_concat_sql

This file has been truncated. show original

Topic		Replies	Views
GeneratedField with PostgreSQL ORM	1	318	July 15, 2024
GeneratedField based on ID Using the ORM	3	418	December 29, 2023
GeneratedField with db_persist=False creates a database column anyway Mystery Errors	4	96	July 8, 2024
Trying to create migration for a GeneratedField yields attribute error Mystery Errors	2	106	July 7, 2024
Migrating scalar to array fails with Postgres ORM	2	659	September 8, 2023

Using GeneratedField with Postgres

Related topics