Postgres: Update only portion of range, preserving other half and bounds.

partial_range_update.sql

UPDATE <TABLE> SET
	<COLUMN>=<RANGE_TYPE>(
		lower(<COLUMN>), -- Swap out for actual value
		upper(<COLUMN>), -- Swap out for actual value
		concat(
			CASE WHEN lower_inc(<COLUMN>) THEN '[' ELSE '(' END,
			CASE WHEN upper_inc(<COLUMN>) THEN ']' ELSE ')' END
		)
	)
WHERE <CONDITION>;