Re: why there is no interval / interval operator?

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: depesz(at)depesz(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: why there is no interval / interval operator?
Date: 2007-11-08 17:30:45
Message-ID: 162867790711080930jf77d7eu29b769627908c050@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

one possible implementation
http://www.pgsql.cz/index.php/PL/pgSQL_%28en%29#Usage_of_PL.2FpgSQL_functions_for_designing_own_operators

Pavel

On 08/11/2007, hubert depesz lubaczewski <depesz(at)depesz(dot)com> wrote:
> is it just a simple ommission, or am i missing something?
>
> we have interval / float8 ( = interval), so i think that adding interval
> / interval ( = float8) should be possible.
>
> depesz
>
> --
> quicksil1er: "postgres is excellent, but like any DB it requires a
> highly paid DBA. here's my CV!" :)
> http://www.depesz.com/ - blog dla ciebie (i moje CV)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-11-08 17:54:43 Re: what is the date format in binary query results
Previous Message Tomáš Vondra 2007-11-08 17:19:04 Re: INSERT performance deteriorates quickly during a large import