from:"James Kitambara"

Re: [SQL] insert into help

2010-09-24 Thread James Kitambara

because of DEFAULT nextval('table1_id_seq'::regclass) James Kitambara Computer System Analyst and Programmer Bank of Tanzania, P.O. Box 2939, Mobile : +255 71 3307632, Dar es Salaam, Tanzania. --- On Wed, 22/9/10, Guillaume Lelarge wrote: From: Guillaume Lelarge Subje

Fw: Re: [SQL] help

2010-05-27 Thread James Kitambara

--- On Thu, 27/5/10, James Kitambara wrote: From: James Kitambara Subject: Re: [SQL] help To: "Nicholas I" Date: Thursday, 27 May, 2010, 14:50 Hello Mr. Nicholas, You can try the following: THIS IS WHAT I TRIED TO SOLVE YOUR PROBLEM, BUT IN ORACLE DBMS (SORRY I

Re: [SQL] Bucketing Row Data in columns

2009-06-25 Thread James Kitambara

to get what you want. Best Regards James Kitambara Database Administrator -ORGINAL MESSAGE --- On Wed, 24/6/09, Sandeep wrote: From: Sandeep Subject: [SQL] Bucketing Row Data in columns To: pgsql-sql

Re: [SQL] Find periods for a given... action set?

2009-06-22 Thread James Kitambara

Hello Mario Splivalo, I found some solution to your question but it is not exact one. ** SELECT a.user_id, a.action_time- (select a2.action_time from actions a2 where a2.user_id = (select a3.user_id from

Re: [SQL] Need help combining 2 tables together

2009-05-22 Thread James Kitambara

: remind me of pizza Best Regards, Muhoji James Kitambara Database Administrator, B.Sc. With Computer Science and Statistics (Hons), National Bureau of Statistics, P.O. Box 796, Tel : +255 22 2122722/3 Fax: +255 22 2130852, Mobile : +255 71 3307632, Dar es Salaam

Re: [SQL] SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps

2009-04-02 Thread James Kitambara

Dear Srikanth, You can solve your problem by doing this THE SQL IS AS FOLLOWS ASSUME TIME INTERVAL 2008-12-07 07:59:59 TO 2008-12-07 08:58:59 AND THE TABLE NAME time_interval COUNT (*) FROM (select customer_id, log_session_id, start_ts, end_ts , end_ts-start_ts as "Interval" from time_

Re: [SQL] pg_dump in windows

2008-09-26 Thread James Kitambara

Hello Ramasubramanian, You don't have to worry about the password. You need to enter the password of the person doing the backup. One the password is provided the backup is executed. I think that anyone executing the pg_dump must be a Super user. Best Regards, James Kita

[SQL] Problem with pg_connect() in PHP

2008-09-25 Thread James Kitambara

_connect() are defined. Unfortunately I am getting the Fatal error: “Call to undefined function pg_connect() in C:\Web\html\Staff_Management\example1.php on line 23” C:\Web\html is my document root. What could be the possible mistake? Anyone to assist me! Best regards, James Kitambara

Re: [SQL] May I have an assistance on CREATE TABLE Command

2008-09-17 Thread James Kitambara

GN KEY) ---ORGINAL MESSAGE--- I think (one of) the point(s) of id fields is not to change them. You can update the region_name field (eg a correct a misspelling), but the id stays the same. That way the district stays connected to the same region. >>