[GENERAL] Grouping My query

2006-11-01 Thread Martin Kuria
Dear Sir/Madam, I have a staff directory, which group staff in various categories I would like to group the staff members in there specific categories, Below is query is query I am running, it works fine and returns the output below. My question is, how do I Group the staff members in there r

Re: [GENERAL] Grouping My query

2006-11-01 Thread Martin Kuria
. +-+ | Martin W. Kuria (Mr.) [EMAIL PROTECTED] ++ From: Richard Huxton To: Martin Kuria <[EMAIL PROTECTED]> CC: pgsql-general@postgresql.org Subject: Re: [GENERAL] Grouping My query Dat

[GENERAL] postgres Recover Deleted Data

2005-01-17 Thread Martin Kuria
Hi, I accidentally deleted two records in one of my tables, the problem I had not done a back for the database. I can I restore my records, please advice how I can recover my deleted records, thanks again. +-+ | Martin W. Kuria (Mr.) [EMAIL PROTEC

[GENERAL] Categories and Sub Categories (Nested)

2006-04-18 Thread Martin Kuria
Hi, I have a postgresql database Table Categories which has the structure like this Cat_ID | Parent_ID | Name 1 | 0 | Automobiles 2 | 0 | Beauty & Health 3 | 1 | Bikes 4 | 1 | Cars 5 | 3 | Suzuki 6 | 3 | Yamaha 7 | 0 | Clothes According to the above Databa

[GENERAL] Unable to connect to PostgreSQL server

2006-04-20 Thread Martin Kuria
hi, I have a problem with my postgresql database it always gives me an error: Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: sorry, too many clients already in ~/includes/DbConnector.php on line 27 Please advice how I can manage my database to han

Re: [GENERAL] string primary key

2006-05-12 Thread Martin Kuria
Using interger as opposed to a character as a primary key has an advantage when it comes to querying data in the table, it is faster searching with an interger as compared to characters date types +-+ | Martin W. Kuria (Mr.) [EMAIL PROTECTED]