> On Wed, May 25, 2016 at 10:38 AM, Simon Riggs <si...@2ndquadrant.com> wrote: > > On 25 May 2016 at 03:52, Kouhei Kaigai <kai...@ak.jp.nec.com> wrote: > >> > >> In a few days, I'm working for a data type that represents matrix in > >> mathematical area. Does people favor to have this data type in the core, > >> not only my extension? > > > > > > If we understood the use case, it might help understand whether to include > > it or not. > > > > Multi-dimensionality of arrays isn't always useful, so this could be good. > > Many natural language and image processing methods extract feature > vectors that then use some simple distance metric, like dot product to > calculate vector similarity. For example we presented a latent > semantic analysis prototype at pgconf.eu 2015 that used real[] to > store the features and a dotproduct(real[], real[]) real function to > do similarity matching. However using real[] instead of a hypothetical > realvector or realmatrix did not prove to be a huge overhead, so > overall I'm on the fence for the usefulness of a special type. Maybe a > helper function or two to validate the additional restrictions in a > check constraint would be enough. > The 'matrix' data type as domain type of real[] is an option to implement. We can define operators on the domain types, thus, it allows us to process large amount of calculation by one operation, in native binary speed.

My only concern is that domain type is not allowed to define type cast. If we could add type cast on domain, we can define type transformation from other array type to matrix. Thanks, -- NEC Business Creation Division / PG-Strom Project KaiGai Kohei <kai...@ak.jp.nec.com> -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers