Received: from mx99.openu.ac.il (arbel.openu.ac.il [147.233.32.4]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA95541 for ; Mon, 3 May 1999 10:31:24 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from talmon.openu.ac.il (talmon.openu.ac.il [147.233.32.11]) by mx99.openu.ac.il (Postfix) with ESMTP for id 621054B5F0; Mon, 3 May 1999 17:30:37 +0300 (IDT) Received: from [147.233.159.109] (mac-herouth.pc.openu.ac.il) by talmon.openu.ac.il (Netscape Messaging Server 3.54) with ESMTP id AAA624C; Mon, 3 May 1999 17:32:48 +0300 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <19798.925739574@sss.pgh.pa.us> References: Your message of Mon, 3 May 1999 12:42:05 +0300 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Mon, 3 May 1999 17:31:12 +0300 To: Tom Lane From: Herouth Maoz Subject: Re: [SQL] Index on date_trunc Cc: pgsql-sql@postgreSQL.org At 16:52 +0300 on 03/05/1999, Tom Lane wrote: > Good thought, but it doesn't actually work, as you'll find as soon > as there are any entries in the table: > > insert into test values ('1999-08-01 10:15'); > ERROR: SQL-language function not supported in this context. Argh. Chastisement taken. But it really ought to have said that when I tried creating the index, oughtn't it? :) Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma