Postgresql Prefix in django orm

Question

How could I go about utilizing the Postgres Prefix Plugin within django? Is there a way to just append an additional WHERE clause to the queries that django runs without going into raw SQL?

Maybe something like this?

Model.objects.filter(field1=2, field2__in=[1,2,3]).where("prefix @> '0123456789'")

stellasia · Accepted Answer · 2015-10-08 17:58:51Z

2

Yes it is possible, this is the extra method on QuerySet. Something like this should do the trick:

 Model.objects.filter(...).extra(where=["prefix @> '0123456789'"])

answered Oct 8, 2015 at 17:58

stellasia

5,6624 gold badges27 silver badges45 bronze badges

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

2 Comments

Jared Mackey Over a year ago

My concern is that it will be deprecated soon according to their docs.

stellasia Over a year ago

As far as I know, there is no fixed deprecation plan yet so it will be there for several versions and at the time they remove it, there will maybe be another way to do that. Right now, the only other way I see to achieve your goal is to use raw sql queries (docs.djangoproject.com/en/1.8/topics/db/sql/…) but you will have to write the whole query yourself.

Collectives™ on Stack Overflow

Postgresql Prefix in django orm

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related