Loading collection data...
Collections are a way for you to organize kata so that you can create your own training routines. Every collection you create is public and automatically sharable with other warriors. After you have added a few kata to a collection you and others can train on the kata contained within the collection.
Get started now by creating a new collection.
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
This comment is hidden because it contains spoiler information about the solution
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.
This comment is hidden because it contains spoiler information about the solution
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
This comment is hidden because it contains spoiler information about the solution
This comment is hidden because it contains spoiler information about the solution
JavaScript translation: https://www.codewars.com/kumite/603a114bfd308f001cae88c9