| 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: | Raw Message | Whole Thread | 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 |