> I think it is a good thing JSON is limited in what types it supports. Otherwise it would contain so much type bloat while at the same time still annoying some

> I think it is a good thing JSON is limited in what types it supports. Otherwise it would contain so much type bloat while at the same time still annoying someone somewhere because his type is not supported by JSON. I wish it had a few more capabilities, but since JS doesn't then JSON won't. > If you are able to pull your data from the database and process it in a programming language of your choice, you can write a custom serializer that takes a tsrange and spits out some JSON, e.g. a JSON array with two items [start, end], which you then can pass on to a client that understands your JSON format. I can definitely do that. My case though is aggregating and serializing into JSON in postgres and loosing type information due already on the query level.