Skip to content

Instantly share code, notes, and snippets.

@fcasco

fcasco/models.py

Created May 25, 2019 22:03
Show Gist options
  • Save fcasco/d4e4d4aaea1e7addbc4dd9b0b82dfc33 to your computer and use it in GitHub Desktop.
Save fcasco/d4e4d4aaea1e7addbc4dd9b0b82dfc33 to your computer and use it in GitHub Desktop.
Download ZIP
Extra SQL en Django. 4
Raw
models.py
Person.objects.extra(select={'email_provider': "(COALESCE(substring(email from '@(.*)$'), ''))"}).order_by('email_provider')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment