* Steven Klassen <[EMAIL PROTECTED]> [2004-10-14 10:07:39 -0700]: > CREATE FUNCTION check_passwd(text,text) RETURNS boolean AS 'SELECT > CASE WHEN passwd = md5($2) THEN true ELSE false END FROM pg_shadow > WHERE usename = $1;' LANGUAGE sql;
Strike that - go with what Michael recommended. I glanced at the password and didn't realize it was brewed with more than just the password string. -- Steven Klassen - Lead Programmer Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Replication & Support Services, (503) 667-4564 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org