agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Gary Stainburn <gary.stainburn@ringways.co.uk>
To: pgsql-sql@postgresql.org
Subject: Re: simple "select / if found" isn't
Date: Fri, 16 Dec 2016 11:41:41 +0000
Message-ID: <201612161141.41135.gary.stainburn@ringways.co.uk> (raw)
In-Reply-To: <C9BFAD75-EB0B-4107-A6D9-31ED34D7AF6D@me.com>
References: <201612161102.37559.gary.stainburn@ringways.co.uk>
	<C9BFAD75-EB0B-4107-A6D9-31ED34D7AF6D@me.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

view thread (6+ messages)

Message-ID: <201612161141.41135.gary.stainburn@ringways.co.uk>
Permalink:  ../201612161141.41135.gary.stainburn@ringways.co.uk/
Also on:    postgresql.org/message-id/201612161141.41135.gary.stainburn@ringways.co.uk

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: gary.stainburn@ringways.co.uk
  Subject: Re: simple "select / if found" isn't
  In-Reply-To: <201612161141.41135.gary.stainburn@ringways.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox