Ad
  • Custom User Avatar

    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.

  • Default User Avatar

    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

  • Custom User Avatar

    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.)

  • Custom User Avatar
  • Default User Avatar

    This comment is hidden because it contains spoiler information about the solution

  • Custom User Avatar

    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

  • Custom User Avatar

    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.

  • Default User Avatar

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

  • Default User Avatar

    This comment is hidden because it contains spoiler information about the solution

  • Custom User Avatar

    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

  • Custom User Avatar

    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

  • Custom User Avatar

    This comment is hidden because it contains spoiler information about the solution

  • Default User Avatar

    This comment is hidden because it contains spoiler information about the solution

  • Custom User Avatar