Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-07 Thread ben hockey
On Dec 7, 2011, at 3:56 PM, Peter Eisentraut wrote: On tis, 2011-12-06 at 15:15 -0500, Tom Lane wrote: TBH, I think that inventing a new datestyle setting "ECMA" would be a more appropriate investment of effort. So we'd have a setting called "ECMA" that's really ISO, and a setting called "IS

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread ben hockey
i may have spoken a little too soon about the format being right... i just took a look at the postgres source code and it would need one more change to completely meet my needs. EncodeDateTime should put a 'Z' for UTC timezone rather than '+0'. with this being the case, do you think there wo

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread ben hockey
On 12/6/2011 4:19 PM, Pavel Stehule wrote: it can be in 9.2 (if will be accepted) - it will be release at summer 2012 http://wiki.postgresql.org/wiki/Submitting_a_Patch Regards Pavel Stehule ok, so i assume your patch is now considered "submitted" and is waiting to be reviewed. i'll wait

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread ben hockey
On 12/6/2011 3:53 PM, Pavel Stehule wrote: I am not sure, if this patch is 100% correct but it does something the name is not ECMA but XSD - I hope, so both formats are same that format works for me. in fact a simple test to see if it would do what i hope for would be to open the develope

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread ben hockey
On 12/6/2011 3:20 PM, Pavel Stehule wrote: I am for ECMA datestyle it is there but just is not public, if I remember well Theoretically some custom output/input transform routine can be very interesting - for domains, for boolean type - but on second hand - the usage of this feature is minima

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread Ben Hockey
i know its been over a year without any activity on this thread but did anything ever come of this? i'd really like to be able to get dates to match the format specified for date time strings in ecmascript 5. a generic way to specify the format would be ideal if it can be done securely. has ther

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-20 Thread Ben Hockey
On May 19, 2010, at 4:31 AM, Mike Fowler wrote: Pavel Stehule wrote: 2010/5/19 Peter Eisentraut : On tis, 2010-05-18 at 18:26 -0400, Ben Hockey wrote: ecmascript 5 is the most recent specification for JavaScript and i would think that having a DATESTYLE format to simplify interoperability

[HACKERS] ecmascript 5 DATESTYLE

2010-05-18 Thread Ben Hockey
hi, i mistakenly had posted this to pgsql-bugs already and got a response (see below - edited). i'm posting here since afaik it is the way i should be requesting new features. my suggestion is to add a DATESTYLE format to match the format specified for date time strings in ecmascript 5.