Re: [PATCHES] Oracle date type compat. functions: next_day, last_day,

2005-06-03 Thread Ron Mayer
David Fetter wrote: On Thu, Jun 02, 2005 at 05:41:46PM +0200, Pavel Stehule wrote: My next patch is implementation least and greatest functions. If will possible I prefere contrib for it, but it's inpossible. ... BTW, the thing about least() and greatest() (basically the row-wise versions of

Re: [PATCHES] Oracle date type compat. functions: next_day, last_day,

2005-06-02 Thread Christopher Kings-Lynne
I expect so less used functions will go to contrib: LNNVL, .. but some functions can by general usefull. There is WIDTH_BUCKET in core too now. Who use it? Width_bucket is in the sql standard... ---(end of broadcast)--- TIP 1: subscribe and uns

Re: [PATCHES] Oracle date type compat. functions: next_day, last_day,

2005-06-02 Thread Pavel Stehule
On Thu, 2 Jun 2005, Tom Lane wrote: > Pavel Stehule <[EMAIL PROTECTED]> writes: > > b) some functions need patch to parser - greatest, least and decode. > > Why? > they has variable number of argument, they are polymorphic. They are not functions, more special form of operators. Maybe it is p

Re: [PATCHES] Oracle date type compat. functions: next_day, last_day,

2005-06-02 Thread Tom Lane
Pavel Stehule <[EMAIL PROTECTED]> writes: > b) some functions need patch to parser - greatest, least and decode. Why? regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [PATCHES] Oracle date type compat. functions: next_day, last_day,

2005-06-02 Thread Pavel Stehule
> > Why not a pgFoundry project called Oracle-Compat or something? There > are plenty of functions etc... that can be included in the package as a > whole. > > Once it is large enough, push it to contrib or vie for core support. > Is exists. Not in very usefull state, true. http://pgfoundry.

Re: [PATCHES] Oracle date type compat. functions: next_day, last_day,

2005-06-02 Thread David Fetter
On Thu, Jun 02, 2005 at 09:17:07AM -0700, Joshua D. Drake wrote: > Pavel Stehule wrote: > >> > >>Are these functions useful enough to be provided as builtins? > >>add_months(), for example, seems to be a less general version of > >>'date' + 'interval'. > > Why not a pgFoundry project called Oracle

Re: [PATCHES] Oracle date type compat. functions: next_day, last_day,

2005-06-02 Thread David Fetter
On Thu, Jun 02, 2005 at 05:41:46PM +0200, Pavel Stehule wrote: > My next patch is implementation least and greatest functions. If > will possible I prefere contrib for it, but it's inpossible. I had > to modify parser. I know so there exists workaround of its, but it's > really ugly. BTW, the t

Re: [PATCHES] Oracle date type compat. functions: next_day, last_day,

2005-06-02 Thread Joshua D. Drake
Pavel Stehule wrote: On Fri, 3 Jun 2005, Neil Conway wrote: Pavel Stehule wrote: http://www.techonthenet.com/oracle/functions/add_months.htm http://www.techonthenet.com/oracle/functions/last_day.htm http://www.techonthenet.com/oracle/functions/next_day.htm http://www.techonthenet.com/oracle/

Re: [PATCHES] Oracle date type compat. functions: next_day, last_day,

2005-06-02 Thread Pavel Stehule
On Fri, 3 Jun 2005, Neil Conway wrote: > Pavel Stehule wrote: > > http://www.techonthenet.com/oracle/functions/add_months.htm > > http://www.techonthenet.com/oracle/functions/last_day.htm > > http://www.techonthenet.com/oracle/functions/next_day.htm > > http://www.techonthenet.com/oracle/functions

Re: [PATCHES] Oracle date type compat. functions: next_day, last_day,

2005-06-02 Thread Neil Conway
Pavel Stehule wrote: http://www.techonthenet.com/oracle/functions/add_months.htm http://www.techonthenet.com/oracle/functions/last_day.htm http://www.techonthenet.com/oracle/functions/next_day.htm http://www.techonthenet.com/oracle/functions/months_between.htm Are these functions useful enough