jtr109/sort.sql

Created November 1, 2017 05:11

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jtr109/053d792f8ac217534f669e55bf6b411f.js"></script>
Save jtr109/053d792f8ac217534f669e55bf6b411f to your computer and use it in GitHub Desktop.

Download ZIP

Update sort of GenericImage queryset

Raw

	UPDATE "area_genericimage"
	SET "sort" =
	CASE WHEN "id" = 40964 THEN 1
	WHEN "id" = 40965 THEN 2
	END
	WHERE "area_genericimage"."id" in (40964, 40965)

Author

jtr109 commented Nov 1, 2017

refererance here

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment