subject:"\[SQL\] date\(\) indexing error.."

Re: [SQL] date() indexing error..

2000-05-26 Thread Tom Lane

"Mitch Vincent" <[EMAIL PROTECTED]> writes: > 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

[SQL] date() indexing error..

2000-05-26 Thread Mitch Vincent

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_i