Re: genomic locus

2017-12-22 Thread Gene Selkov
irect way to clone a varlena structure (possibly assigning an differently-sized contig to it)? One that is also memory-safe? Thank you, —Gene > Gene Selkov wrote: >>> On Dec 17, 2017, at 7:57 PM, Robert Haas >> <mailto:robertmh...@gmail.com> <mailto:robertmh..

Re: genomic locus

2017-12-21 Thread Gene Selkov
Hi Oleg, Great to hear from you. I wondered how many of the old-timers were still around. > Why not use composite type ? For simple interval approach it's worked for us > (see attached hdate.sql). I have just begun looking at your hdate example; I see potentially useful stuff in it, but the fir

Re: genomic locus

2017-12-21 Thread Gene Selkov
> On Dec 18, 2017, at 6:59 AM, Craig Ringer wrote: > > If you think it'd make logical sense to extend seg with a string descriptor > of some sort and could come up with a name/use case that's not quite so > narrowly focused as genetics alone, then I could see adding it as a secondary > type i

Re: genomic locus

2017-12-21 Thread Gene Selkov
> On Dec 18, 2017, at 5:00 AM, PostgreSQL - Hans-Jürgen Schönig > wrote: > > 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 th

Re: genomic locus

2017-12-21 Thread Gene Selkov
> On Dec 17, 2017, at 7:57 PM, Robert Haas wrote: > > On Fri, Dec 15, 2017 at 2:49 PM, Gene Selkov wrote: >> 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

Re: genomic locus

2017-12-21 Thread Gene Selkov
Nice work, Andrew! I wish I knew about it earlier. > On Dec 16, 2017, at 8:53 AM, Andrew Dunstan > wrote: > > I keep most of the out-of-tree extensions I maintain green by building > and testing them in a buildfarm member. That way I become aware pretty > quickly if any API change has broken t

Re: genomic locus

2017-12-21 Thread Gene Selkov
> On Dec 15, 2017, at 4:50 PM, Michael Paquier > wrote: > If you wish to fix seg in some way, you could always > patch them. But I am not sure what you are trying to fix, so more > details would be welcome. I was contemplating how much functionality I could borrow from seg to build another int

genomic locus

2017-12-15 Thread Gene Selkov
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 year