timestamp format escape rules - Mailing list pgsql-hackers

From Rikard Pavelic
Subject timestamp format escape rules
Date
Msg-id 20150312090743.0000354f@ngs.hr
Whole thread Raw
List pgsql-hackers
Currently Postgres uses DATE WHITESPACE TIME for timestamp/tz datatype.

Due whitespace it needs to be escaped when returned as record.
How likely is to change WHITESPACE to something more ISO like, like 'T'?

This would allow it to be serialized without the need for escaping.

I'm asking this since we often return nested records directly from
Postgres and when reading deeply nested records, we are mostly skipping
on quotes/escapes.

Regards,
Rikard

-- 
Rikard Pavelic
https://dsl-platform.com/
http://templater.info/



pgsql-hackers by date:

Previous
From: Julien Tachoires
Date:
Subject: Re: patch : Allow toast tables to be moved to a different tablespace
Next
From: Etsuro Fujita
Date:
Subject: Re: EvalPlanQual behaves oddly for FDW queries involving system columns