Jeff Hoffmann wrote:
> select zip, location <@> '(lat, lon)'::box
> from zipcodes
> order by location <@> '(lat, lon)'::box
> limit 10;
>
oops, typo. those boxes should be points. plus, it looks like you can
get zipcodes & lat-longs from the census at:
http://ftp.census.gov/geo/www/gazet
"Len Morgan" <[EMAIL PROTECTED]> writes:
> The reason that IMHO this deserves a little consideration (i.e., doing it at
> all rather than just saying "Don't store any files in PG_DATA") is that
> RedHat based rpm installations create the postgres superuser account as part
> of the process and set
Actually I was thinking more on the lines of:
select location from test where location @ '((31.6283,93.6347), 1.39)'::circle;
The above lat/lon is for: Zwolle, LA
If Zylks, LA (lat/lon = 32.9696,93.9801) is also in the DB.
The above query should select Zylks since 1.39 * 62.1 = 86 miles approx.
I'm sure that my bash supports chinese .
And the cat ,less command also display chinese well.
I using the GB code chinese.
Thank U!
On Tue, May 16, 2000 at 10:52:33PM +0200, SimeX wrote:
> ...
>
> Argg, You should read a database's book.
I wonder what you saw on this table definition that warrants such a
response. Since I did not read the original mail maybe you just didn't quote
the relevant parts, so I'm curious.
M
>> A slightly more reasonable example is where the admin has already
>> inserted his own pg_hba.conf in the directory; would be nice if initdb
>> didn't overwrite it (nor delete it on failure), but I'm not sure it's
>> worth the trouble.
>
>I am inclined to leave it as is too. I can imagine many
I am not sure if the is the best place to ask this question or if it is
better asked on the hackers or sql list, but here it goes...
I have created a new data type (I call it a fieldlist) in postgresql
which is basically a label-value string. The advantage to this is that
I can effectively exten
Thanks for the help on the libperl question. I bet recompiling the
sources will fix my problem.
There is an error in the example in the file: triggers20290.htm. All the
elog statements list "WARN" as the first parameter. However WARN is not
defined in elog.h (or, it seems, anywhere else). In
Tom Lane wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> >> It seems like it would be a whole lot "nicer" if initdb only deleted
> >> the files that it attempted to create OR if the default was not to
> >> delete anything.
>
> > Okay, I could go for the former. What do others think?
>
> I
Hello I want to use a SIG called grass under linux redhat6.1. This
SIG can connect to postgresql to obtain table describing geographic
object like sites, polugon etc...
Unfortunately all this information are under oracle (I think it's a
7.0 release). Now I've telecharged the "oracle-odbc-0
> Thanks for the help on the libperl question. I bet recompiling the
> sources will fix my problem.
>
> There is an error in the example in the file: triggers20290.htm. All the
> elog statements list "WARN" as the first parameter. However WARN is not
> defined in elog.h (or, it seems, anywhere
In working on my book, I have found another problem with libpgeasy. It
uses the old-style PQsetdb() arg parameters, rather than the newer
opt=val PQconnectdb() parameters.
I have changed libpgeasy to use this new style. This change will appear
in 7.0.1. It is not optimal to do this in a minor
Why is text the recommended character data type?
Is it accessed faster than the other data types?
Jesse
--
Jesse Estevez
Director of E-Commerce
[EMAIL PROTECTED]
Travel-Italy.com
2400 Bluff Creek Drive
Columbia, Missouri 65201
USA
Toll Free (
Jeffery Collins <[EMAIL PROTECTED]> writes:
> So, with that prefix, is there a way to pass an argument to a
> CREATE INDEX function? If not, is this something that would be possible
> to add? If it is possible, is it desireable? If it is possible and
> desireable, where would I start if I were
Travis Bauer <[EMAIL PROTECTED]> writes:
> On another note, I noticed that when you load a dynamically loaded c
> library using the create funtion statement in psql, the library is never
> reloaded unless you quit psql and restart it, even if you "drop function",
> change the library, and recreate
15 matches
Mail list logo
