Re: [SQL] insert into help

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 guilla...@lelarge.info wrote: From: Guillaume Lelarge guilla

Fw: Re: [SQL] help

--- On Thu, 27/5/10, James Kitambara jameskitamb...@yahoo.co.uk wrote: From: James Kitambara jameskitamb...@yahoo.co.uk Subject: Re: [SQL] help To: Nicholas I nicholas.domni...@gmail.com Date: Thursday, 27 May, 2010, 14:50 Hello Mr. Nicholas,   You can try the following:   THIS IS WHAT

Re: [SQL] Bucketing Row Data in columns

to get what you want.   Best Regards   James Kitambara Database Administrator -ORGINAL MESSAGE --- On Wed, 24/6/09, Sandeep gibsos...@gmail.com wrote: From: Sandeep gibsos...@gmail.com Subject: [SQL] Bucketing

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

;   ***   Maybe you can use it as the BASE. It only refer to the first BEGIN for each user. If you can do some modification on that you can reach to the required solution Best Regards James Kitambara Database Administrator

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

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

Re: [SQL] pg_dump in windows

  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 Kitambara

[SQL] Problem with pg_connect() in PHP

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

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

KEY in DISTRICT  table is also updated.   I will appriciate for your assistance ! Regards   James Kitambara  

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

--- 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. James Kitambara [EMAIL PROTECTED] 2008-09-17 8:50   Hello Mambers

[SQL] MAY I HAVE YOUR ASSISTANCE

    0003 |  IT-MANAGER |   ^8Y3U(-43873GDG?   I appriciate for your assistance in advance,   Sincerely yours,   James Kitambara, PostgreSQL user.