Re: genomic locus
Hans-Jürgen Schönig <postgres@cybertec.at>
From: PostgreSQL - Hans-Jürgen Schönig <postgres@cybertec.at>
To: Gene Selkov <selkovjr@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2017-12-18T11:00:38Z
Lists: pgsql-hackers
hello … maybe this one is also helpful: https://wiki.postgresql.org/images/1/1b/Postbis_pgcon_eu_2012.pdf it seems they have put a lot of work into that. regards, hans > On 15 Dec 2017, at 20:49, Gene Selkov <selkovjr@gmail.com> wrote: > > Greetings everyone, > > I need a data type to represent genomic positions, which will consist of a string and a pair of integers with interval logic and access methods. Sort of like my seg type, but more straightforward. > > I noticed somebody took a good care of seg while I was away for the last 20 years, and I am extremely grateful for that. I have been using it. In the meantime, things have changed and now I am almost clueless about how you deal with contributed modules and what steps I should take once I get it to work. Also, is it a good idea to clone and fix seg for this purpose, or is there a more appropriate template? Or maybe just building it from scratch will be a better idea? > > I have seen a lot of bit rot in other extensions (never contributed) that I have not maintained since 2009 and I now I am unable to fix some of them, so I wonder how much of old knowledge is still applicable. In other words, is what I see in new code just a change of macros or the change of principles? > > Thanks, > > --Gene -- Cybertec Schönig & Schönig GmbH Gröhrmühlgasse 26, A-2700 Wiener Neustadt Web: http://www.postgresql-support.de <http://www.postgresql-support.de/>, http://www.cybertec.at <http://www.cybertec.at/>