Re: using a function in where - Mailing list pgsql-general

From Andrew Gierth
Subject Re: using a function in where
Date
Msg-id 87bm633w74.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to using a function in where  (Glenn Schultz <glenn@bondlab.io>)
List pgsql-general
>>>>> "Glenn" == Glenn Schultz <glenn@bondlab.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)


pgsql-general by date:

Previous
From: Glenn Schultz
Date:
Subject: using a function in where
Next
From: Alban Hertroys
Date:
Subject: Re: using a function in where