Changeset 469

Timestamp:

10/03/09 14:09:16 (15 years ago)

Author:

nanardon

Message:

• fix query with new aliases management

File:

• LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/User.pm (modified) (1 diff)

LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/User.pm

@@ -210 +210 @@
     } elsif ($field eq 'aliases') {
         my $sth = $self->db->prepare(q{
-            select name from aliases where forward = ?
+            select name from aliases where array[lower($1)] <@
+                string_to_array(lower(array_to_string("forward", ',')), ',')
         } . ($self->base->{wexported} ? '' : 'and exported = true'));
         $sth->execute($self->id);