Re: Limitations of PostgreSQL

Wow, I must be missing something, because I cannot even dream up a case
where I think I might find a use for the mysql INTERVAL() function, far
less actually NEED it  :)

Terry

Michael Fuhr wrote:
> On Wed, Oct 12, 2005 at 04:49:59PM -0500, Scott Marlowe wrote:
>
>>On Wed, 2005-10-12 at 16:16, Chris Travers wrote:
>>
>>>Compared to MySQL, I can't think of any downsides.  All relevant
>>>usability issues have been solved, though there are some functions like
>>>INTERVAL that are not supported (see my migration guide at
>>>http://www.metatrontech.com/wpapers/)
>>
>>What, exactly, is the interval function in MySQL?  IS that one that
>>creates a sequence of numbers or whatnot?  If so, there is an equivalent
>>in 8.0 now.  By the way, interval is a SQL reserved keyword, so it's
>>surprising MySQL would choose to name a function after it.
>
>
> Surprising?  C'mon now, this is MySQL :->
>
> Here's an excerpt from the MySQL documentation:
>
> INTERVAL(N,N1,N2,N3,...)
>     Returns 0 if N < N1, 1 if N < N2 and so on or -1 if N is
>     NULL.  All arguments are treated as integers.  It is required
>     that N1 < N2 < N3 < ... < Nn for this function to work
>     correctly.  This is because a binary search is used (very fast).
>
>     mysql> SELECT INTERVAL(23, 1, 15, 17, 30, 44, 200);
>             -> 3
>     mysql> SELECT INTERVAL(10, 1, 10, 100, 1000);
>             -> 2
>     mysql> SELECT INTERVAL(22, 23, 30, 44, 200);
>             -> 0
>

--
Terry Fielder
terry@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085