les approx.
86 miles is about correct for those two zip codes.
Wouldn't this be much easier?
Is the data type POINT index-able?
Yes, I have all of the zip codes and lat/lon information.
Thanks
Andy
On Thu, 18 May 2000, Jeff Hoffmann wrote:
> Andy Lewis wrote:
> >
> > Hell
Hello All,
I know there's been quite a few posts on Zip Code Proximity.
Can anyone point me in the right direction to find the code to calulate
the distance between two zip codes?
I'm basically trying to take a zip code given by a user and return them
all of the zip codes within, say 10 miles o
And so am I.
Andy
On Tue, 25 Apr 2000, Ed Loehr wrote:
> Stephan Richter wrote:
> >
> > >Do you know if Edmund (Mergl) has written a DBD driver for Pg7 yet?
>
> I am running DBD::Pg 0.93 with pg7 and it works fine.
>
For starters I head over to www.postgresql.org
Then I'd probably click on the "Info Central" link and then the "Mailing
lists" link.
>From there I'd click on the list that I was subscribed to under "Mailing
List Archives"
Then I'd read the info at the top of the page.
Those pages haven't r
I'd also like to hear from anyone on the original posters topic of the "24
hour shop".
I too am in that same boat. I have a DB with 7-8 million records on a Dual
550 with 512Meg Ram and 1gig swap and it takes vacuum 10 - 15 minutes each
evening to run.
Users think the site is hosed and managemen
The URL http://www.vale-it.co.uk doesn't work for me.
Andy
On Wed, 29 Mar 2000, Moray McConnachie wrote:
> Try pgadmin, which is not web-based, but allows you to do all these things.
> Only runs from MS platform, though.
> http://www.vale-it.co.uk
>
> Alternatively, it would be mind-numbingly
Thanks for the info!
Much appreciated!
Andy
On Thu, 26 Aug 1999, Mike Mascari wrote:
> --- Andy Lewis <[EMAIL PROTECTED]> wrote:
> > What scheduler are we speaking of here?
> >
> > Andy
> >
> > On Thu, 26 Aug 1999, Bruce Momjian wrote:
> >
&
What scheduler are we speaking of here?
Andy
On Thu, 26 Aug 1999, Bruce Momjian wrote:
> > as for the processor, this will see an increase, of course. note,
> > however, that since PostgreSQL is _not_ multithreaded, that it will run
> > only on one of the processors. (i'm about to assume you ar
Its not really, really explanitory.
On Mon, 24 May 1999, Brett W. McCoy wrote:
> On Sun, 23 May 1999, Bruce Momjian wrote:
>
> > We have a fulltext stuff in the contrib directory.
>
> What's it called? I only see some tcl frontend stuff. Despite my
> pessimism form the prior message, I a
The only thing that I know is whats in the docs and whats in the src
directory. I'd like to see/read more. I was going to pick up a Oracle book
on it but, I'm afraid that PL/pgSQL and PL/SQL aren't the same.
Thanks
Andy
On Sat, 22 May 1999, dustin sallings wrote:
> On Sat,
now() even
though it should default to now(), it works fine.
Maybe this message would be better posted in the hackers list.
Andy
d, 12 May 1999, Chris Bitmead
wrote:
> It's not a timezone problem is it? Did the dates get re-loaded
> correctly?
>
> Andy Lewis wrote:
> >
>
I have 2 tables both of which have a datetime field and both have an
identifier of date_submitted.
I've been using(via PHP) a query of the following for a month or so with
no problem:
select count(*) from mytable1 where date_submitted > 'today'::datetime
and
select count(*) from mytable2 where
Postgres is allowed to access that file. No error message on the:
cat plpgsql.so > /dev/null
Andy
On Wed, 28 Apr 1999, Oleg Broytmann wrote:
> On Wed, 28 Apr 1999, Andy Lewis wrote:
> > I got the following error after trying to copy the example at:
> > http://
Thanks I'll give it a try!
Andy
On Tue, 27 Apr 1999, [iso-8859-1] José Soares wrote:
>
>
> Andy Lewis ha scritto:
>
> > How does one compile or add PL/pgSQL if it doesn't already exist?
> >
> > I've searched the DOCS and mailing list and the
How does one compile or add PL/pgSQL if it doesn't already exist?
I've searched the DOCS and mailing list and the best that I can come up
with is an enable script that complains about the missing .sql file.
I'm running 6.4.2
Thanks in advance.
Andy
I tried this but, got the following:
---
mytest=> select fagentname from feedback where ftdate between now()::date and
mytest-> (now()::datetime - '@ 7 days'::timespan)::date;
ERROR: function date(timestamp) does not exist
-
Compile Postgres with the "--with-perl" switch and be sure that you also use the
"--prefix=BASEDIR" switch.
Once finished see "src/interfaces" for more info such as test.pl
Hope this helps!
Andy
On Tue, 26 May 1998, Ricardo Romero wrote:
>Hi, I'm a new user the PostgreSQL and new with Perl t
17 matches
Mail list logo
