Ah, that should work.
The README for contrib/cube states:
To install the type, run
make
make install
For this to work, make sure that:
. the cube source directory is in the postgres contrib
directory
. the user running "make install" has postgres
administrative authority
. this user's environment defines the PGLIB and PGDATA
variables and has
postgres binaries in the PATH.
So I did:
$ export PGLIB=/usr/lib/pgsql
$ export PGDATA=/var/lib/pgsql/data
$ make
$ make install
mkdir /usr/share/pgsql/contrib
make: *** [installdirs] Error 1
$ pg_config --configure
'--prefix=/usr' '--datadir=/usr/share/pgsql'
'--libdir=/usr/lib/pgsql'
'--includedir=/usr/include/pgsql'
Is PGLIB and/or PGDATA ignored? What should I do so
'make install' works?
Thanks,
CSN
--- Bruce Momjian <pgman@candle.pha.pa.us> wrote:
>
> Didn't /contrib/earthdistance help?
>
>
---------------------------------------------------------------------------
>
> CSN wrote:
> > I looked through the docs and contrib, but didn't
> see
> > anything related to storing and using latitude and
> > longitude values. I have data in the form of 12�
> 34'
> > N, 12� 34' W.
> >
> > Would any of the geometric data types work well
> for
> > this type of data? Or just convert them to
> decimals?
> > Are there any functions for converting lat/long
> > to/from decimals/DDMMSS NSEW?
> >
> > Thanks
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Mail is new and improved - Check it out!
> > http://promotions.yahoo.com/new_mail
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the
> unregister command
> > (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
> >
>
> --
> Bruce Momjian |
> http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610)
> 359-1001
> + If your life is a hard drive, | 13 Roberts
> Road
> + Christ can be your backup. | Newtown
> Square, Pennsylvania 19073
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
