[GENERAL] Re: A question multibye
From: Siamack Jabbarzadeh [EMAIL PROTECTED] Subject: A question multibye Date: Fri, 06 Jul 2001 18:56:53 Message-ID: [EMAIL PROTECTED] Dear Sir/Madam: I have some questions on multibye languages and I hope you can help me? First I was wondering if there is a table (like ASCII table) for multibyte languages? I am not sure what you want, but PostgreSQL allows default encoding per database, not per table. Second, Assuming we have an input made up of some Japanese letters mixed with special character like and % (which have ASCII values). Now I would like to write a parser that takes and % out and leaves only Japanese letters. Knowing the fact that and % are ASCII and the letters are mulitbyte, I can not do the parsing by comparing byte by byte ( as we do in normal ASCII). How can I do that? Do % and have multibye values in multibye systems? if yes, how can I get those values? Could you kindly ( if you have some solutions to the problem), give me some hints on that? Japanese has several encodings. I recomend you to use EUC-JP. (Extended Unix Code for Japanese). With EUC-JP, it's very easy to distinguish Japanese from ASCII even paring byte by byte. If a byte is greater than 7f, then it should be a Japanese, otherwise ASCII. Anyway, I recommend you to study about Japanese encodings first. See: ftp://ftp.ora.com/pub/examples/nutshell/ujip/doc/cjk.inf -- Tatsuo Ishii ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: Re: [GENERAL] index on a box
Tom Lane£¬ Does anyone who knows a user's information is storeed in what pgSQL's system table? Thank all! ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[GENERAL] Postgres and C/C++
Hello all, Where would I find examples of some C files that connect to a postgresql db I am just starting out with c and know Postgresql rather well and have done a lot of development with PHP. So I need to know what else do I need to write a C program that will connect to a database in Postgresql and thus interact with that database. The interface I am trying to create is in windows with Postgresql in linux. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[GENERAL] How should I phrase this?
I've got a table that I insert a value and a timestamp now(). Then I want to delete entries that are older than 30 minutes old. After some experimentation, I found the following works, but it looks awkward and backwards. Is there a better, more readable way of phrasing this or rewriting it? DELETE FROM generators WHERE age(now(),started) interval '30 minutes' -- Paul Tomblin [EMAIL PROTECTED], not speaking for anybody Nobody can be told what the dominatrix is, they have to see it for themselves ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[GENERAL] (no subject)
set nomail ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] QUERY - Including the new LDP PostgreSQL HOWTO in the main PostgreSQL distribution
Hi all, We've had the go-ahead from the Linux Documentation Project (LDP) guys to create a new PostgreSQL HOW-TO for a while now. I was going to start it off just to make sure we had something, so that it could be put around instead of Al Dev's Database Guide (the bad one). Well, I haven't had time. Here's my thought, I'd like to know what people think. - How about we create a new PostgreSQL HOW-TO, have it as part of the main distribution, and have that be the one which the LDP guys use? They use DocBook format, as do we, and I feel this will allow us to keep a very in-sync relationship between the new PostgreSQL HOW-TO and the present version. It also means that no one person has total control of it, and it can be contributed to by anyone that has a suggestion and/or can generate a diff. So, what do people think? :-) Regards and best wishes, Justin Clift ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[GENERAL] inserting columns with values from a different table
Hello all, This may be (hopefully) a very basic question, but I (admittedly, a pgsql newbie) cannot seem to be able to find an answer to it :( I have in my database tables, say A, B, and C, all of them referring to the same objects (e.g. table A contains customer's name, table B his/her purchases, and table C his/her address). I want to create a master table D whose rows would have some values from table A, some from B, and some from C (e.g. name, last purchase, and address). I know I can do an INSERT with SELECT - but that will only allow me to insert values from one table, not from all three (or more). Is there any way to do this in PostgreSQL? I do realize that I could likely imitate everything I need from a master table by having many different tables and executing [more or less] complicated queries, but having a master table would greatly simplify my life and avoid multiple potential mistakes when constructing those queries... Thanks! Alex ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] datatype for indexable char field larger than 256
Thomas T. Thai writes: i'm parsing DMOZ data files, and i need to store the path and later reference it to get the associated CatID to store for the parent of the child paths. however, some of the paths are larger than 500 chars. would a WHERE clause like this: ... WHERE path='top/this/really/long/500/char/path' work if i define the field 'path' as type text? Sure, you can store up to 1 GB in a text field. also, type text field aren't indexable or are they? Sure they are. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[GENERAL] Re: libssl.so.0, libcrypto.so.0 needed when installing RPM 7.1.2 on RH 6.2?
These libs are supposed to be part of the OpenSSL distribution, I think. Make sure you have installed the openssl package. If OpenSSL is installed and you still have problems, the library name might be the problem. Create a softlink, then: libcrypto.so.0 -- libcrypto.so.0,9.6 Regards, Peter Giovanni B. Stefanoni wrote: I downloaded postgresql RPM 7.1.2 from postgresql.org, binary version built for Redhat 6.2. When installing the package rpm reports a dependency error, not finding libssl.so.0 libcrypto.so.0. where can i find these two libraries? None of packages in RH 6.2 CD contains that. thank you. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: Re: [GENERAL] index on a box
select * from pg_users; From: ÀîÁ¢Ð [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Tom Lane [EMAIL PROTECTED], Dustin Sallings [EMAIL PROTECTED] CC: [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Re: Re: [GENERAL] index on a box Date: Sun, 08 Jul 2001 21:02:32 +0800 Tom Lane£¬ Does anyone who knows a user's information is storeed in what pgSQL's system table? Thank all! ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Postgres and C/C++
Brian C. Doyle [EMAIL PROTECTED] writes: Where would I find examples of some C files that connect to a postgresql db I am just starting out with c and know Postgresql rather well and have done a lot of development with PHP. The interface I am trying to create is in windows with Postgresql in linux. Then you'll probably need to install the PG ODBC driver and learn the ODBC interface. The nice thing about that is that it works with pretty much any database, so you can switch to Sybase or Oracle or whatever quite easily (not that you'd want to, of course ;) There should be plenty of ODBC programming info on the web. -Doug -- The rain man gave me two cures; he said jump right in, The first was Texas medicine--the second was just railroad gin, And like a fool I mixed them, and it strangled up my mind, Now people just get uglier, and I got no sense of time... --Dylan ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] How should I phrase this?
An alternative, though I'm not sure it's better in any way : DELETE FROM generators WHERE started + '30 minutes'::interval = now(); -Mitch - Original Message - From: Paul Tomblin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 08, 2001 2:12 PM Subject: [GENERAL] How should I phrase this? I've got a table that I insert a value and a timestamp now(). Then I want to delete entries that are older than 30 minutes old. After some experimentation, I found the following works, but it looks awkward and backwards. Is there a better, more readable way of phrasing this or rewriting it? DELETE FROM generators WHERE age(now(),started) interval '30 minutes' -- Paul Tomblin [EMAIL PROTECTED], not speaking for anybody Nobody can be told what the dominatrix is, they have to see it for themselves ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [GENERAL] How should I phrase this?
Quoting Mitch Vincent ([EMAIL PROTECTED]): An alternative, though I'm not sure it's better in any way : DELETE FROM generators WHERE started + '30 minutes'::interval = now(); Well, that looks a little nicer. Thanks. -- Paul Tomblin [EMAIL PROTECTED], not speaking for anybody Q: How did you get into artificial intelligence? A: Seemed logical -- I didn't have any real intelligence. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Bad news for Open Source databases, acording to survey
--- Bruce Momjian [EMAIL PROTECTED] wrote: Here is an article saying open source databases will not make major inroads into large businesses during the next five years: http://itmanagement.earthweb.com/datbus/article/0,,11969_796851,00.html Those same weak arguments were used to discredit Linux as a valid OS just a couple years ago. They dissappeared with the increasing vendor support (Dell, IBM, etc) just as GreatBridge and Red Hat are doing so now for PostgreSQL. Plus, with so many youngsters coming out of college armed with experience with open source tools like PostgreSQL it is silly to assume that the current DB giants will reign supreme years from now given such powerful alternatives. I could go on with endless arguments to prove the logic of that article incorrect but for most of you it would simply be a waste of time. We have been there and heard that all before. PostgreSQL will continue to grow as the community around it grows and I have faith in that as I would imagine most of you do as well. Regards, Brent __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] Why is it not using the other processor?
Tom Lane wrote: http://thingy.kcilink.com/modperlguide/debug/Handling_the_User_pressed_Stop_.html I am not sure how practical that is though; does the web server even find out about it when the user presses Stop in a typical browser? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]