Received: from icebox.venux.net (icebox.venux.net [216.120.166.10]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA18738 for ; Fri, 26 May 2000 10:30:13 -0400 (EDT) (envelope-from mitch@venux.net) Received: from servbox.venux.net (matrix.venux.net [216.120.166.5]) by icebox.venux.net (Postfix) with ESMTP id F348026202 for ; Fri, 26 May 2000 10:34:28 -0400 (EDT) Received: from doot (doot.venux.net [10.0.0.65]) by servbox.venux.net (Postfix) with SMTP id 013502BD82 for ; Fri, 26 May 2000 10:33:11 -0400 (EDT) Message-ID: <00a601bfc71f$05ed13c0$4100000a@venux.net> From: "Mitch Vincent" To: Subject: date() indexing error.. Date: Fri, 26 May 2000 10:31:04 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200005/159 Using PostgreSQL 7.0 I'm Doing ... ipa2=# CREATE INDEX "app_stat_month" on applicant_stats(date(month)); ERROR: SQL-language function not supported in this context. ipa2=# \d applicant_stats Table "applicant_stats" Attribute | Type | Modifier -----------+-----------+---------- app_id | integer | month | date | user_id | integer | view_time | timestamp | Index: app_id When I try and do the above there is one record in the database. ipa2=# select * from applicant_stats; app_id | month | user_id | view_time --------+------------+---------+------------------------------ 56941 | 05-26-2000 | 291 | Fri May 26 09:19:41 2000 EDT (1 row) If I erase it I get the same error, only when I try and insert data into the table.. I'm doing these kind of indexes on several tables, this is the only one I'm having this occur.. Any ideas? Thanks! -Mitch