t idea! Up to now, I basically used IFS='|' with
tuples-only, but it's not clean wrt. '\n' within the data.
I didn't check your patch if it gets this "right", but if it does, it
would ease daily work (where I check for '\n' in the data beforeha
;)) / 60;
> ?column?
> --
> 13311989.7435394
> (1 row)
Even shorter, an interval can be used directly:
emails=# select extract(epoch from now() - '2010-01-01 11:45:13'::timestamp)/60;
?column?
592150.7494153
(1 row)
--
Jan-Benedict Glaw jbg...@lug-owl.de +49-172-7608481
Signature of: Friends are relatives you make for yourself.
the second :
signature.asc
Description: Digital signature
ith, who can take part in this. Sergey Karpov has done extensive benchmarks
> of q3c, rtree and pgsphere and found the latter still has some benefits
> in some workload, so we are interesting in development.
Could the PostGIS stuff be abused for stellar coordinates?
MfG, JBG
--
Jan
On Wed, 2012-01-11 00:43:25 +0400, Oleg Bartunov wrote:
> On Tue, 10 Jan 2012, Jan-Benedict Glaw wrote:
> > On Sun, 2012-01-08 22:19:53 +0400, Oleg Bartunov wrote:
> > > pgsphere now could benefit very much from our KNNGiST feature.
> > > This is number one developme
