Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.2/8.9.1) with ESMTP id MAA66483 for ; Tue, 30 Mar 1999 12:21:35 -0500 (EST) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id LAA24222; Tue, 30 Mar 1999 11:21:31 -0600 (CST) Received: from unknown(144.210.12.10) by gauntlet.bjke.com via smap (4.1) id xma023472; Tue, 30 Mar 99 11:20:46 -0600 Received: by cpsmail with Internet Mail Service (5.5.2448.0) id ; Tue, 30 Mar 1999 11:21:13 -0600 Message-ID: From: "Jackson, DeJuan" To: Herouth Maoz , pgsql-sql@postgreSQL.org Subject: RE: [SQL] indexing a datetime by date Date: Tue, 30 Mar 1999 11:21:12 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" > How about using the ANSI standard CURRENT_DATE instead of either? It's > already of type date. Or is it considered a function call? > > Herouth Not sure how PostgreSQL implements that. It would appear to be implemented just as now(). Try: select CURRENT_DATE::TIME, now()::TIME; -DEJ