Received: from guerilla.foo.bar (qmailr@hennen32s.iserlohn.netsurf.de [194.195.194.226]) by hub.org (8.9.2/8.9.1) with SMTP id KAA38403 for ; Sat, 30 Jan 1999 10:19:30 -0500 (EST) (envelope-from sas@schell.de) Received: (qmail 3156 invoked by uid 1000); 30 Jan 1999 15:20:17 -0000 Date: Sat, 30 Jan 1999 16:20:17 +0100 From: Sascha Schumann To: pgsql-sql@hub.org Subject: index on aggregate function Message-ID: <19990130162017.A3151@schell.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.1i X-Operating-System: Linux guerilla 2.2.1 I somewhere read that it is possible to create an index on aggregate functions in PostgreSQL. Which syntax do I have to use for it? test=> CREATE TABLE test ( name VARCHAR(32) ); CREATE test=> CREATE INDEX test_idx ON test lower(name); ERROR: parser: parse error at or near "lower" gives me a parser error. -- Regards, Sascha Schumann | Consultant | finger sas@schell.de | for PGP public key