Re: My second PL/pgSQL function - minor problem - Mailing list pgsql-novice

On 2009-11-20, Jasen Betts <jasen@xnet.co.nz> wrote:
> On 2009-11-18, Thomas Løcke <thomas.granvej6@gmail.com> wrote:
>> --001517402ba882fac30478a73b83
>> Content-Type: text/plain; charset=ISO-8859-1
>>
>> Hey all,
>>
>> http://pastebin.com/f1015226d

> your function seems basically equivalent to
>
>  UPDATE users SET lastvisit = now(), visits = visits + 1
>      WHERE username = uname AND password = passwd
>      RETURNING id;
      --------------

should be:
  RETURNING *;

oops.