Re: How to I select value of GUC that has - in its name?

2021-02-09 Thread Edward Macnaghten
On 09/02/2021 14:40, hubert depesz lubaczewski wrote: > Hi, > question from IRC, but I couldn't find an answer. > > I can set custom guc with - in name, but I can't figure out how to > select it. > > Without minus, it works great: > > =$ psql -X -c 'show custom.guc' > ERROR: unrecognized configura

Re: Recursive Queries

2020-04-16 Thread Edward Macnaghten
On 16/04/2020 14:36, Edward Macnaghten wrote: > On 16/04/2020 09:35, Alex Magnum wrote: >> Hi, >> I have a simple table with singupĀ timestamps >> >> What I would like to do is to create a table as shown below that >> displays the counts per our for the past n dates

Re: Recursive Queries

2020-04-16 Thread Edward Macnaghten
On 16/04/2020 09:35, Alex Magnum wrote: > Hi, > I have a simple table with singupĀ timestamps > > What I would like to do is to create a table as shown below that > displays the counts per our for the past n dates. Various ways, but for me... SELECT hour, SUM(CASE(WHEN date = date THEN 1 ELSE 0)),