Re: using a function in where

> "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

Re: psql is hanging

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

Re: postgis after pg_upgrade

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 >