From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
---|---|
To: | Glenn Schultz <glenn(at)bondlab(dot)io> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: using a function in where |
Date: | 2018-12-03 07:32:02 |
Message-ID: | 87bm633w74.fsf@news-spur.riddles.org.uk |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>>>>> "Glenn" == Glenn Schultz <glenn(at)bondlab(dot)io> writes:
Glenn> All,
Glenn> I am using the function below to convert a continuous variable
Glenn> to a binned value. Sometimes a value other than zero is passed
Glenn> through the query. For example -.5 result value is passed to the
Glenn> query result. The basic of the query is below.
Glenn> select
Glenn> incentivebin(wac, rate, .25)
Glenn> from
Glenn> my_table
Glenn> where incentivebin(was, rate, .25) = 0
Those two calls to incentivebin() have different parameters - is that an
error in the original query, or a typo in transcribing it to email?
--
Andrew (irc:RhodiumToad)
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2018-12-03 08:10:28 | Re: using a function in where |
Previous Message | Glenn Schultz | 2018-12-03 07:06:29 | using a function in where |