Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-07 Thread Peter Eisentraut
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 ISO that's really SQL, and a setting called SQL that's really

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 ISO

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-07 Thread Pavel Stehule
2011/12/7 ben hockey neonstalw...@gmail.com: 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

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

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread Robert Haas
On Tue, Dec 6, 2011 at 1:11 PM, Ben Hockey neonstalw...@gmail.com wrote: 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

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Tue, Dec 6, 2011 at 1:11 PM, Ben Hockey neonstalw...@gmail.com wrote: 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

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread Pavel Stehule
2011/12/6 Tom Lane t...@sss.pgh.pa.us: Robert Haas robertmh...@gmail.com writes: On Tue, Dec 6, 2011 at 1:11 PM, Ben Hockey neonstalw...@gmail.com wrote: 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

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

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread Pavel Stehule
2011/12/6 ben hockey neonstalw...@gmail.com: 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

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread Pavel Stehule
2011/12/6 ben hockey neonstalw...@gmail.com: 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

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

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread Pavel Stehule
2011/12/6 ben hockey neonstalw...@gmail.com: 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

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 Pavel Stehule
2011/12/6 ben hockey neonstalw...@gmail.com: 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

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

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread Pavel Stehule
Hello 2011/12/6 ben hockey neonstalw...@gmail.com: 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

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 pete...@gmx.net: 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

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-20 Thread Robert Haas
On Thu, May 20, 2010 at 9:25 PM, Ben Hockey neonstalw...@gmail.com wrote: thanks for looking into adding this feature.  custom formats for parsing and formatting of dates would certainly be the better option if it can be done securely. Well, Pavel expressed a concern about SQL injection, but I

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-19 Thread 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 with JavaScript applications would be highly desirable. Note that we haven't got any other datestyles

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-19 Thread Pavel Stehule
2010/5/19 Peter Eisentraut pete...@gmx.net: 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 with JavaScript applications would be highly desirable.

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-19 Thread Mike Fowler
Pavel Stehule wrote: 2010/5/19 Peter Eisentraut pete...@gmx.net: 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 with JavaScript applications

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-19 Thread Pavel Stehule
2010/5/19 Mike Fowler m...@mlfowler.com: Pavel Stehule wrote: 2010/5/19 Peter Eisentraut pete...@gmx.net: 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

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-19 Thread Mike Fowler
Pavel Stehule wrote: see google: lateral sql injection oracle NLS_DATE_FORMAT I would to like this functionality too - and technically I don't see a problem - It's less than 100 lines, but I don't need a new security problem. So my proposal is change nothing on this integrated functionality and

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-19 Thread Pavel Stehule
2010/5/19 Mike Fowler m...@mlfowler.com: Pavel Stehule wrote: see google: lateral sql injection oracle NLS_DATE_FORMAT I would to like this functionality too - and technically I don't see a problem - It's less than 100 lines, but I don't need a new security problem. So my proposal is change

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-19 Thread Mike Fowler
Pavel Stehule wrote: 2010/5/19 Mike Fowler m...@mlfowler.com: Pavel Stehule wrote: see google: lateral sql injection oracle NLS_DATE_FORMAT I would to like this functionality too - and technically I don't see a problem - It's less than 100 lines, but I don't need a new security

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-19 Thread Pavel Stehule
2010/5/19 Mike Fowler m...@mlfowler.com: Pavel Stehule wrote: 2010/5/19 Mike Fowler m...@mlfowler.com: Pavel Stehule wrote: see google: lateral sql injection oracle NLS_DATE_FORMAT I would to like this functionality too - and technically I don't see a problem - It's less than 100

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-18 Thread Robert Haas
On Tue, May 18, 2010 at 6:26 PM, Ben Hockey neonstalw...@gmail.com wrote: 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

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-18 Thread Pavel Stehule
2010/5/19 Robert Haas robertmh...@gmail.com: On Tue, May 18, 2010 at 6:26 PM, Ben Hockey neonstalw...@gmail.com wrote: 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