Skip to content

=$
|

  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 18
    • … PostgreSQL 17
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact

Month: January 2016

Waiting for 9.6 – Allow to omit boundaries in array subscript

On 18th of December, Teodor Sigaev committed patch:

Allow to omit boundaries in array subscript
 
Allow to omiy lower or upper or both boundaries in array subscript
for selecting slice of array.
 
Author: YUriy Zhuravlev

Continue reading Waiting for 9.6 – Allow to omit boundaries in array subscript

Posted on 2016-01-102019-05-15|Tags array, arrays, pg96, postgresql, subscripts, waiting|

Waiting for 9.6 – Cube extension kNN support

On 18th of December, Teodor Sigaev committed patch:

Introduce distance operators over cubes:
<#> taxicab distance
<->  euclidean distance
<=> chebyshev distance
 
Also add kNN support of those distances in GiST opclass.
 
Author: Stas Kelvich

Continue reading Waiting for 9.6 – Cube extension kNN support

Posted on 2016-01-102019-05-15|Tags cube, geometry, gist, knn, knngist, performance, pg96, postgresql, waiting|

Search

Follow me

  • Comments RSS
  • Posts RSS

PostgreSQL

  • Documentation
  • Explain Analyze analyzer
  • IRC help channel
  • Mailing Lists search
  • PG Planet
  • PostgreSQL Home Page

About me

  • CPAN
  • GitLab
  • Linked In
  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 18
    • … PostgreSQL 17
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact