[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: Re: [SQL] simple "select / if found" isn't
From: Gary Stainburn <gary.stainburn () ringways ! co ! uk>
Date: 2016-12-16 11:41:41
Message-ID: 201612161141.41135.gary.stainburn () ringways ! co ! uk
[Download RAW message or body]
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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic