Re: [GENERAL] Zip Code Proximity

2000-05-18 Thread Andy Lewis
. 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: Hello All, I know there's been

Re: anybody know who the damn list owner is? RE: [GENERAL] Postgresqlism Vacuum?

2000-04-14 Thread Andy Lewis
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

Re: [GENERAL] Web-based PSQL?

2000-03-29 Thread Andy Lewis
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

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Andy Lewis
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 are

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Andy Lewis
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: as for the processor, this will see an increase, of course

Re: [GENERAL] PL/pgSQL - mailng list

1999-05-24 Thread Andy Lewis
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, 22 May 1999, Andy

Re: [GENERAL] Full Text Searches

1999-05-24 Thread Andy Lewis
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 am

Re: [GENERAL] Weird datetime problem

1999-05-11 Thread Andy Lewis
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

Re: [GENERAL] PLpgSQL Stat Problem

1999-04-28 Thread Andy Lewis
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://www.postgresql.org/mhonarc

Re: [GENERAL] PL/pgSQL

1999-04-27 Thread Andy Lewis
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 best that I can come up with is an enable script

RE: [GENERAL] SELECT Date

1998-10-12 Thread Andy Lewis
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