Re: [GENERAL] Does Psql support Chinese?

2000-05-18 Thread cc21cn
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!

Re: [GENERAL] Performance

2000-05-18 Thread Michael Meskes
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.

Re: [GENERAL] initdb and exit_nicely...

2000-05-18 Thread Len Morgan
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 bug

[GENERAL] Passing arguments to and INDEX function.

2000-05-18 Thread Jeffery Collins
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

[GENERAL] Error in manual

2000-05-18 Thread Travis Bauer
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

Re: [GENERAL] initdb and exit_nicely...

2000-05-18 Thread Jeffery Collins
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? It'd be a bit of

[GENERAL] connect postgresql to a oracacle database

2000-05-18 Thread Pascal IMBERT
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

Re: [GENERAL] Error in manual

2000-05-18 Thread Bruce Momjian
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

[GENERAL] Change to libpgeasy connectdb() call

2000-05-18 Thread Bruce Momjian
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

[GENERAL] Character Data Types, Why is Text Best?

2000-05-18 Thread Jesse Estevez
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

Re: [GENERAL] Passing arguments to and INDEX function.

2000-05-18 Thread Tom Lane
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 to

Re: [GENERAL] Error in manual

2000-05-18 Thread Tom Lane
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 the

Re: [GENERAL] Zip Code Proximity

2000-05-18 Thread Jeff Hoffmann
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:

Re: [GENERAL] initdb and exit_nicely...

2000-05-18 Thread Tom Lane
"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 the

Re: [GENERAL] Zip Code Proximity

2000-05-18 Thread Andy Lewis
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