How to return default value if field is NULL?

Question

I need analog of sql IS_NULL function. In postgres, for example, I can write like this

coalesce(field, 'Empty')

How I can implement this using Django?

You mean... http://stackoverflow.com/questions/844556/django-filter-how-do-i-go-about-filtering-for-empty-or-null-names-in-a-querys? — netcoder, Nov 23 '13 at 13:53
Not exactly. I need replace all null values with deafult value. Not only detect them — m9_psy, Nov 23 '13 at 17:50

score 2 · Accepted Answer · answered Nov 24 '13 at 09:47

2

You can use extra queryset method:

MyModel.objects.extra(select={'field': "coalesce(field, 'Empty')"})

COALESCE should work similarly in most db engines.

answered Nov 24 '13 at 09:47

mariodev

its changing my float field to u'unicode'. I want float in return. how to? – A.J. Apr 21 '14 at 07:00

1 Answers1