Re: using a function in where

2018-12-02 Thread Andrew Gierth
> "Glenn" == Glenn Schultz 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 basi

using a function in where

2018-12-02 Thread Glenn Schultz
All, I am using the function below to convert a continuous variable to a binned value. Sometimes a value other than zero is passed through the query. For example -.5 result value is passed to the query result. The basic of the query is below. select incentivebin(wac, rate, .25) from my_table whe

Re: How to watch for schema changes

2018-12-02 Thread Igor Korot
Hi, Adrian, Sorry for the delay to come back to this. I was busy doing other things. On Tue, Jul 3, 2018 at 12:32 PM Adrian Klaver wrote: > > On 07/03/2018 10:21 AM, Igor Korot wrote: > > Hi, ALL, > > Is there any trigger or some other means I can do on the server > > which will watch for CREATE/

Re: psql is hanging

2018-12-02 Thread Christopher Browne
I like the "add an analyze" idea; the two most likely causes of the phenomenon (to my mind) are either: a) Something's getting locked and Tom Lane's idea of checking pg_locks when you notice it's stopped can help track down the problem. Further to that, the thing I'd be expecting to see if the pr

Re: postgis after pg_upgrade

2018-12-02 Thread Slavcho Trnkovski
Hi, This will not resolve the issue I have because extension is already to the latest version, but it is using postgres 9.4 and it should use 9.6. Regards, Slavcho On Fri, Nov 30, 2018 at 6:01 PM Paul Ramsey wrote: > If you install the new version, and then use ‘ALTER EXTENSION UPDATE’ to > up