KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
CREATE OR REPLACE FUNCTION _chkLogin(userid varchar, pwd varchar) RETURNS BOOLEAN AS $BODY$ DECLARE passed BOOLEAN; BEGIN SELECT (_password = $2) FROM _vRegistration WHERE _userid = $1; RETURN passed; END; $BODY$ LANGUAGE 'plpgsql'; When am executing the code above am getting the following error, SELECT _chkLogin('username','abcd') as passed; ERROR: query has no destination for result data I've used perform then i get a different problem, PERFORM _chkLogin('username','abcd'); ERROR: syntax error at or near "perform" Suggest me what should I be doing in order to overcome this error.
Tags (comma-separated)
Save Edits
Cancel