| From: | Rikard Pavelic <rikard(at)ngs(dot)hr> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | timestamp format escape rules |
| Date: | 2015-03-12 08:07:43 |
| Message-ID: | 20150312090743.0000354f@ngs.hr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Etsuro Fujita | 2015-03-12 08:30:56 | Re: EvalPlanQual behaves oddly for FDW queries involving system columns |
| Previous Message | Julien Tachoires | 2015-03-12 07:01:23 | Re: patch : Allow toast tables to be moved to a different tablespace |