Changeset 1460 for trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/User.pm

Timestamp:

11/03/15 18:10:02 (9 years ago)

Author:

nanardon

Message:

Make query to find aliases easier

File:

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

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

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