Would be nice for a long test to provide some estimation of %% completion.
'''if(i%(BIG_SIZE/10)==0) printf("%2.0f of the Addition test passed\n",(double)i/BIG_SIZE);'''

That would give some clue if the solution is on the right track and need only cosmetical enhancments.

I think it would be much better if instead of writing about SQL magic, it would simply inform users about the creation of the operator.

I don't understand the task at all! Why in the sample table are 2 rows with the same user na same username. Example:
id = 1
user_id = 1
name = a

and few rows below

id = 3
user_id 1
name = a

Lovely kata! Just to clarify: the cost for passing a given coordinate will always be a natural number (i.e. an integer greater than 0), correct? (This is suggested by the formulation "moving to a neighboring coordinate counted not as 1 step but as N steps", but it could be stated more explicitly.)

Scala translation

Hey guys, can someone give me a hint on this one? I've been trying it for quite some time.
I'm using a BFS, but at this point I'm not quite sure if this is a good approach. A DFS would be any better?

Edit: scrolling down I saw my old post, from 6 months ago, hahah wow

I have a solutions that works using 'create function - unnest - ordinality - cardinality', but still I hece the same error:
I do not what is happening....any suggestion? Thks

--- Caused by: ---

PG::UndefinedFunction:

ERROR: operator does not exist: integer[] + integer[]

LINE 1: SELECT id, a, b, c, a + b AS "a + b", (a + b) + c AS "(a + b...

^

HINT: No operator matches the given name and argument types. You might need to add explicit type casts.

/usr/local/bundle/gems/sequel-5.47.0/lib/sequel/adapters/postgres.rb:156:in `exec'

No examples found.

I'm stuck at the monthly/yearly totals. I can get the daily totals, but dont know how to insert the others.

I'm rather new to this and I never have made a function let alone try to alter a binary operator. This is using the CREATE FUNCTION ultility within the language, yes?
https://www.postgresql.org/docs/current/sql-createfunction.html

hi there.
as i'm quite new to the sql kata's and just did the select challanges until now, i'm wondering how these update challenges work.
i'm thinking, that these would be an UPDATE attempts SET name = ??
where did i get the values from?
i'm really lost on that one :/ and would really appreciate some hints

JavaScript translation: https://www.codewars.com/kumite/603a114bfd308f001cae88c9