Re: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL

Do Options and One-Click seem oxymoronic to anyone else? > On Jan 1, 2019, at 5:18 PM, chiru r wrote: > > Yes, at this moment we are not considering symlinks. > > We would like to have the options in RPMs itself. > >> On Tue, Jan 1, 2019 at 3:53 PM Brent Wood wrote: >> Have you considered sym

Re: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL

Yes, at this moment we are not considering symlinks. We would like to have the options in RPMs itself. On Tue, Jan 1, 2019 at 3:53 PM Brent Wood wrote: > Have you considered symlinking the default paths to where you want it to > reside? > > That approach would allow updates & upgrades to work a

Re: Query help

On 1/1/19 12:05 PM, David G. Johnston wrote: On Tuesday, January 1, 2019, Adrian Klaver > wrote: On 1/1/19 11:26 AM, John W Higgins wrote: with accounts_over_total as ( select accountid from transactions where sum(amount) >= 50 group

Re: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL

Have you considered symlinking the default paths to where you want it to reside? That approach would allow updates & upgrades to work as they expect, without changing default paths or config files. Much as described here:https://help.cloud66.com/rails/how-to-guides/databases/shells/change-psql-di

Re: Query help

On Tuesday, January 1, 2019, Adrian Klaver wrote: > On 1/1/19 11:26 AM, John W Higgins wrote: >> >> with accounts_over_total as ( >> select accountid from transactions where sum(amount) >= 50 group by >> accountid) >> > > Unfortunately there is a hitch in the above:( > > select p_item_no from pro

Re: Query help

On 1/1/19 11:26 AM, John W Higgins wrote: On Tue, Jan 1, 2019 at 11:06 AM Chuck Martin > wrote: Sorry if this is too basic a question for this list, but I don't fully get how to use aggregates (sum()) and group-by together. I'm trying to get a list o

Re: Query help

On 1/1/19 11:05 AM, Chuck Martin wrote: Sorry if this is too basic a question for this list, but I don't fully get how to use aggregates (sum()) and group-by together. I'm trying to get a list of transactions where the total for a given account exceeds a given number. I'm not sure an example is

Re: Query help

On Tuesday, January 1, 2019, David G. Johnston wrote: > On Tuesday, January 1, 2019, Chuck Martin > wrote: > >> results wanted-all transactions where account total >= 50 >> >> id. amount. accountid.name >> 1. 50. 1 bill >> 3. 75.

Query help

On Tuesday, January 1, 2019, Chuck Martin wrote: > results wanted-all transactions where account total >= 50 > > id. amount. accountid.name > 1. 50. 1 bill > 3. 75. 1 bill > 4 25.

Re: Query help

On Tue, Jan 1, 2019 at 11:06 AM Chuck Martin wrote: > Sorry if this is too basic a question for this list, but I don't fully get > how to use aggregates (sum()) and group-by together. I'm trying to get a > list of transactions where the total for a given account exceeds a given > number. I'm not

RE: Query help

Any columns that aren’t involved in a summary operation (think math type or some other type of summary operation) have to be in the group by statement. From what you show below, I would try something like this (untested): Select accountid,name,sum(amount) from table where sum(amount) >’50’ group

Query help

Sorry if this is too basic a question for this list, but I don't fully get how to use aggregates (sum()) and group-by together. I'm trying to get a list of transactions where the total for a given account exceeds a given number. I'm not sure an example is needed, but if so, consider this simplified

Re: Thoughts on row-level security for webapps?

On 12/31/18 8:57 AM, Siegfried Bilstein wrote: Hi all, I'm evaluating using a tool called Postgraphile that generates a GraphSQL server from a postgres setup. The recommended way of handling security is to implement RLS within postgres and simply have the webserver take a cookie or similar an

Re: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL

On 12/31/18 8:19 AM, chiru r wrote: Hi All, I wanted to install the PostgreSQL-11 Software with Custom installation/binary paths. Currently I am using EDB one click installer software with option file like below to achieve, However EDB stopped and no longer provides one click installer for