Received: from intus.net (216-99-209-129.cust.aracnet.com [216.99.209.129] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id OAA87097 for ; Thu, 19 Aug 1999 14:37:46 -0400 (EDT) (envelope-from gelbardn@intus.net) Received: from floyd (floyd [216.99.209.129]) by intus.net (8.9.3/8.9.3) with SMTP id LAA05909 for ; Thu, 19 Aug 1999 11:37:37 -0700 (PDT) Date: Thu, 19 Aug 1999 11:37:37 -0700 (PDT) From: Nathan Gelbard X-Sender: gelbardn@floyd To: pgsql-sql@postgresql.org Subject: searching time arrays Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Greetings SQLians; given the table below, how would i determine which name is avail on a givin day at a givin time? the time arrays contain an a list of hours a support person is available; '{09:00:00,10:00:00,11:00:00,12:00:00}' etc. any thoughts? thanx natez CREATE TABLE support_sched ( name varchar(30), monday time[], tuesday time[], wednesday time[], thursday time[], friday time[], saturday time[], sunday time[] ); Nate Gelbard office: 503.284.0369 Straylight Research fax : 516.828.8533