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
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
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
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
>
> 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.
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
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
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/
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
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
Hello
This patch is implementation of some date functions which produce better
compatibility with Oracle (On request Radim Kolar). Major changes are in
/src/backend/utils/adt/oracle_compat.c. There are new functions: next_day,
last_day, add_months and months_between.
Original Oracle doc
http:
11 matches
Mail list logo