Re: simple "select / if found" isn't

From: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: simple "select / if found" isn't
Date: 2016-12-16 11:41:41
Message-ID: 201612161141.41135.gary.stainburn@ringways.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Friday 16 December 2016 11:34:48 Jan Otto wrote:
>
> return exists(select 1 from user_previous_passwords
> where u_id=ID and crypt(PASS,u_previous_password) =
> u_previous_password);
>
> > END;
> > $$ LANGUAGE plpgsql;
>
> regards, jan

What a muppet am I???????

It had to be something that simple, but I was going code blind. The ironic
bit was that the where clause was the only thing that remained the same with
ever different idea I tried.

Thanks Jan

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message tank.zhang 2016-12-31 04:29:48 How to use postgresql generated generated always COLUMN ?
Previous Message Jan Otto 2016-12-16 11:34:48 Re: simple "select / if found" isn't