On 11/30/19 4:08 AM, Alexander Farber wrote:
My context is that I have a table of player moves with PK mid (aka "move
id").
And I am able to find "interesting" moves by the high score or all 7
letter tiles used.
But I do some human reviewing and set a "puzzle" boolean for truly
interesting
My context is that I have a table of player moves with PK mid (aka "move
id").
And I am able to find "interesting" moves by the high score or all 7 letter
tiles used.
But I do some human reviewing and set a "puzzle" boolean for truly
interesting moves.
For the reviewing tool I would like to disp
On 11/29/19 11:47 AM, Alexander Farber wrote:
Thank you Adrian, but -
if I remove GROUP BY mid, then I get the error:
ERROR: 42803: column "words_moves.mid" must appear in the GROUP BY
clause or be used in an aggregate function
LINE 18: mid,
^
LOCATION: check_un
On Fri, Nov 29, 2019 at 12:48 PM Alexander Farber <
alexander.far...@gmail.com> wrote:
>
> if I remove GROUP BY mid, then I get the error:
>
> ERROR: 42803: column "words_moves.mid" must appear in the GROUP BY clause
> or be used in an aggregate function
> LINE 18: mid,
>
Thank you Adrian, but -
On Fri, Nov 29, 2019 at 6:45 PM Adrian Klaver
wrote:
> On 11/29/19 8:38 AM, Alexander Farber wrote:
> >
> > CREATE OR REPLACE FUNCTION words_list_puzzles(
> > in_start interval,
> > in_end interval
> >
> > ) RETURNS TABLE (
> >
On 11/29/19 8:38 AM, Alexander Farber wrote:
Good evening,
I am trying to count the booleans per each GROUP BY section by the
following stored function:
CREATE OR REPLACE FUNCTION words_list_puzzles(
in_start interval,
in_end interval
) RETURNS TABL
Good evening,
I am trying to count the booleans per each GROUP BY section by the
following stored function:
CREATE OR REPLACE FUNCTION words_list_puzzles(
in_start interval,
in_end interval
) RETURNS TABLE (
out_label text,
