My second PL/pgSQL function - minor problem

From: Thomas Løcke <thomas(dot)granvej6(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: My second PL/pgSQL function - minor problem
Date: 2009-11-18 15:52:40
Message-ID: 1f0fa7ae0911180752m27776744n4760c3698781fdab@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hey all,

http://pastebin.com/f1015226d

The above function appears to be doing exactly what I want: Fetch the users
data and update the visits column, if the supplied credentials match a user.

My problem is what happens when the credentials don't match a user. In those
cases I would like to have a boolean false returned, but instead I get an
empty array - which of course is entirely according to the functions "RETURN
SETOF users" statement.

Is this little problem solvable, or will I have to learn to live with the
empty array?

Regards,
Thomas

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2009-11-18 16:18:48 Re: My second PL/pgSQL function - minor problem
Previous Message Tom Lane 2009-11-17 23:54:05 Re: 8.38 -> 8.5?