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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With