Django ArrayField with different types

Question

I need to configure a django.contrib.postgres.fields.ArrayField with a list of pairs in which the fist element is a float and the second, a small positive integer:

data = [[1.23, 3], [2.42, 1], [3.72, 29]]

How could I do this? Is it possible? I tried something like this, but didn't work:

class MyModel(models.Model):
    my_field = ArrayField(
                   models.FloatField(default=0),                        
                   models.PositiveSmallIntegerField(default=0),
                   null=True
               )

Why do you need to do this? Can this not be solved with two floats? — Sayse
– Sayse, Commented Feb 3, 2017 at 10:03
I know I can solve with two floats. I just want to know if I can use different field types inside an ArrayField. — msampaio
– msampaio, Commented Feb 3, 2017 at 10:04

Sayse · Accepted Answer · 2017-02-03 10:08:03Z

4

I just want to know if I can use different field types inside an ArrayField.

No, this is not possible, it would involve a very confusing way to get the data out of the database, as well as no way of really setting the field type in the database to a concrete type.

Instead, just use a two float fields

my_field = ArrayField(
    ArrayField(
        models.FloatField(default=0),
        size=2,
    )
)

answered Feb 3, 2017 at 10:08

Sayse

43.4k14 gold badges85 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

psilocybin · Accepted Answer · 2019-10-03 16:00:22Z

1

If you really need this functionality, you could try JSONField:

class MyModel(models.Model):
    my_field = JSONField()

And store '[[1.23, 3], [2.42, 1], [3.72, 29]]' in this, though it does raise questions about the design of your data model.

answered Oct 3, 2019 at 16:00

psilocybin

1,1151 gold badge7 silver badges26 bronze badges

Comments

MD. SHIFULLAH · Accepted Answer · 2023-04-12 06:45:00Z

0

You can Try this:

from django.contrib.postgres.fields import ArrayField
from django.db import models

class Author(models.Model):
   name = models.CharField(max_length=1024)
   books_list = ArrayField(
       models.CharField(max_length=1024)
   )

answered Apr 12, 2023 at 6:45

MD. SHIFULLAH

1,84515 silver badges20 bronze badges

Collectives™ on Stack Overflow

Django ArrayField with different types

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related