Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-07 Thread Pavel Stehule
2011/12/7 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'

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-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'

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread Pavel Stehule
Hello 2011/12/6 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 bei

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 Pavel Stehule
2011/12/6 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 "sub

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 : > > > 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 w

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 Pavel Stehule
2011/12/6 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 seco

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread Pavel Stehule
2011/12/6 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 seco

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 Pavel Stehule
2011/12/6 Tom Lane : > Robert Haas writes: >> On Tue, Dec 6, 2011 at 1:11 PM, Ben Hockey 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 stri

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread Tom Lane
Robert Haas writes: > On Tue, Dec 6, 2011 at 1:11 PM, Ben Hockey 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 gen

Re: [HACKERS] ecmascript 5 DATESTYLE

2011-12-06 Thread Robert Haas
On Tue, Dec 6, 2011 at 1:11 PM, Ben Hockey 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 > way to specify the

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 Robert Haas
On Thu, May 20, 2010 at 9:25 PM, Ben Hockey 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 can't see why that

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

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-19 Thread Pavel Stehule
2010/5/19 Mike Fowler : > Pavel Stehule wrote: >> >> 2010/5/19 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 line

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-19 Thread Mike Fowler
Pavel Stehule wrote: 2010/5/19 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

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-19 Thread Pavel Stehule
2010/5/19 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 noth

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 : > 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 interop

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-19 Thread Mike Fowler
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 with JavaScript applications would be highly

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-18 Thread Pavel Stehule
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 with JavaScript applications would be highly >> desirable. > > Note

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-18 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 datesty

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-18 Thread Pavel Stehule
2010/5/19 Robert Haas : > On Tue, May 18, 2010 at 6:26 PM, Ben Hockey 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 DATES

Re: [HACKERS] ecmascript 5 DATESTYLE

2010-05-18 Thread Robert Haas
On Tue, May 18, 2010 at 6:26 PM, Ben Hockey 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 to > match the for

[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.