[GENERAL] Re: A question multibye

2001-07-08 Thread Tatsuo Ishii
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

Re: Re: [GENERAL] index on a box

2001-07-08 Thread ÀîÁ¢ÐÂ
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++

2001-07-08 Thread Brian C. Doyle
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

[GENERAL] How should I phrase this?

2001-07-08 Thread Paul Tomblin
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?

[GENERAL] (no subject)

2001-07-08 Thread R Talbot
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

2001-07-08 Thread Justin Clift
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

[GENERAL] inserting columns with values from a different table

2001-07-08 Thread Alexander Turchin
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

Re: [GENERAL] datatype for indexable char field larger than 256

2001-07-08 Thread Peter Eisentraut
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

[GENERAL] Re: libssl.so.0, libcrypto.so.0 needed when installing RPM 7.1.2 on RH 6.2?

2001-07-08 Thread Peter C. A. Bär
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

Re: Re: [GENERAL] index on a box

2001-07-08 Thread omid omoomi
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

Re: [GENERAL] Postgres and C/C++

2001-07-08 Thread Doug McNaught
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

Re: [GENERAL] How should I phrase this?

2001-07-08 Thread Mitch Vincent
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

Re: [GENERAL] How should I phrase this?

2001-07-08 Thread Paul Tomblin
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

Re: [GENERAL] Bad news for Open Source databases, acording to survey

2001-07-08 Thread Brent R. Matzelle
--- 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

Re: [GENERAL] Why is it not using the other processor?

2001-07-08 Thread Mithun Bhattacharya
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