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

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] Bucketing Row Data in columns

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

Fw: Re: [SQL] help

--- 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] insert into help

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

[SQL] MAY I HAVE YOUR ASSISTANCE

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

[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

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. >>

[SQL] Problem with pg_connect() in PHP

_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] 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 Kita

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 time_

Re: [SQL] Need help combining 2 tables together

   : 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