Order By A Column That Is Type Json

Yii 1.1 General Discussion
1

Does anyone know a way I can order by a column that is type json? (I am using POSTGRESQL)

I have my data displaying correctly in my CGridView Widget but when I try to sort by the field that is of json type I get the following error:


CDbCommand failed to execute the SQL statement: SQLSTATE[42883]: Undefined function: 7 ERROR: could not identify an ordering operator for type json

LINE 1: SELECT * FROM "field" "t" ORDER BY "t"."brand" LIMIT 10