we have a query to get all jobs with changes inside a certain time period. Depending on the selected period the performance goes from <100 milliseconds for a day to ~7 seconds for a week. I found ...
Tag: postgresql-9.2
How to use LIKE with ANY in Postgresql?
Is there a way to do a partial string match on a string array column in postgres? I’m trying the following syntax, but it is not working as I’d expect it to: Is there a correct way of doing this? Answer
42501: INSUFFICIENT PRIVILEGE ERROR while querying in Postgresql
I am trying to query a database table in postgresql, but every time I run the below query it gives me the INSUFFICIENT PRIVILEGE error. What possibly could be the reason for such permission denied …