[GENERAL] Problem with create index

[Rajesh Kumar Mallah]

Hmmm... am i doing anything really silly?

tradein_clients=# CREATE INDEX profile_master2 on profile_master (lower( btrim(email) 
) );
ERROR:  parser: parse error at or near "(" at character 61
tradein_clients=#


Regds
mallah.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match