pgsql/create_optional_types_and_functions-dovecot-1.2.x.pgsql
branchv0.6.x
changeset 485 10e9b4855173
parent 437 9823548b2717
equal deleted inserted replaced
484:35395b49bc44 485:10e9b4855173
   395 --      varchar localpart
   395 --      varchar localpart
   396 --      varchar the_domain
   396 --      varchar the_domain
   397 -- Returns: dovecotpassword records
   397 -- Returns: dovecotpassword records
   398 --
   398 --
   399 -- Required access privileges for your dovecot database user:
   399 -- Required access privileges for your dovecot database user:
   400 --      GRANT SELECT ON users, domain_name TO dovecot;
   400 --      GRANT SELECT ON users, domain_name, service_set TO dovecot;
   401 --
   401 --
   402 -- For more details see http://wiki.dovecot.org/AuthDatabase/SQL
   402 -- For more details see http://wiki.dovecot.org/AuthDatabase/SQL
   403 -- ---
   403 -- ---
   404 CREATE OR REPLACE FUNCTION dovecotpassword(
   404 CREATE OR REPLACE FUNCTION dovecotpassword(
   405     IN localpart varchar, IN the_domain varchar) RETURNS SETOF dovecotpassword
   405     IN localpart varchar, IN the_domain varchar) RETURNS SETOF dovecotpassword