← Back to branch summary

~azzar1/unity/add-show-desktop-key

« back to all changes in this revision

Viewing changes to userdb/users.sql

  • Committer: William Grant
  • Date: 2010-02-23 08:55:42 UTC
  • mto: This revision was merged to the branch mainline in revision 1674.
  • Revision ID: grantw@unimelb.edu.au-20100223085542-r8xw14bxxoraza51
Permit underscores in all names.

Show diffs side-by-side

added added

removed removed

Lines of Context:
userdb/users.sql
4
4
CREATE OR REPLACE FUNCTION valid_url_name(name text) RETURNS boolean AS 
5
5
$$
6
6
    BEGIN
7
 
        RETURN name ~ E'^[a-z0-9][a-z0-9\+\.\-]*$';
 
7
        RETURN name ~ E'^[a-z0-9][a-z0-9_\+\.\-]*$';
8
8
    END;
9
9
$$ LANGUAGE 'plpgsql';
10
10
 
13
13
CREATE OR REPLACE FUNCTION valid_login_name(name text) RETURNS boolean AS 
14
14
$$
15
15
    BEGIN
16
 
        RETURN name ~ E'^[a-z0-9][a-z0-9\+\.\-@_]*$';
 
16
        RETURN name ~ E'^[a-z0-9][a-z0-9@_\+\.\-]*$';
17
17
    END;
18
18
$$ LANGUAGE 'plpgsql';
19
19