Re: using a function in where

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: using a function in where
Дата
Msg-id 87bm633w74.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на using a function in where  (Glenn Schultz <glenn@bondlab.io>)
Список 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 по дате отправления: