function index like lower(column)

[cevin]

create unique index t3_uname on test3 (lower(username));
//error:invalid syntax: statement ignored: syntax error: unimplemented: unimplemented at or near ")"

<?php

$stmt = $pdo->prepare("select * from test3 where lower(username)  = :username");
$stmt->bindValue(':username',strtolower($_GET['username']));
$stmt->execute();
$stmt->fetchAll(PDO::FETCH_ASSOC);

[jordanlewis]

Hi, you're looking for a "computed index": an index on an expression, not just a column. This feature is currently unsupported in CockroachDB and is tracked in #9682.