Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id KAA03901 for postgres-dist; Wed, 19 Jan 1994 10:38:27 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199401191838.KAA03901@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.149.14]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id KAA03892 for ; Wed, 19 Jan 1994 10:38:27 -0800 Received: from localhost (aoki@localhost) by faerie.CS.Berkeley.EDU (8.6.4/8.1B) id KAA17322; Wed, 19 Jan 1994 10:37:40 -0800 Message-Id: <199401191837.KAA17322@faerie.CS.Berkeley.EDU> From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: gatto@ltid.inpe.br (Gatto) Cc: postgres@postgres.Berkeley.EDU Subject: Re: correcting my last message (time intervals) In-reply-to: Your message of Wed, 19 Jan 94 16:21:39 EDT <9401191821.AA00597@ltid.inpe.br> Date: Wed, 19 Jan 1994 10:37:39 -0800 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Wed, 19 Jan 94 10:38:27 -0800 Resent-XMts: smtp gatto@ltid.inpe.br (Gatto) writes: > retrieve (MSG.all) where MSG.time ["Mon Jan 17 10:58:28 1994 WDT", > "Mon Jan 17 10:59:29 1994 WDT"]\g the syntax for tinterval is actually ['Mon Jan 17 10:58:28 1994 WDT' 'Mon Jan 17 10:59:29 1994 WDT'] and i would write it "['Mon Jan 17 10:58:28 1994 WDT' 'Mon Jan 17 10:59:29 1994 WDT']"::tinterval if the parser complains that it can't figure out the type. general advice to people who are bitten by syntax: the regression tests (in src/regress/regress) contain examples of many different types of queries. -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki