Details

    • Type: Sub-task Sub-task
    • Status: Resolved
    • Priority: Trivial Trivial
    • Resolution: Fixed
    • Fix Version/s: 1.1.1
    • Component/s: API
    • Labels:
      None

      Description

      It would be nice to add a native syntax for the use of ReversedType. I'm sure there is anything in SQL that we inspired ourselves from, so I would propose something like:

      CREATE TABLE timeseries (
        key text,
        time uuid,
        value text,
        PRIMARY KEY (key, time DESC)
      )
      

      Alternatively, the DESC could also be put after the column name definition but one argument for putting it in the PK instead is that this only apply to keys.

      1. 4004.txt
        6 kB
        Sylvain Lebresne
      2. 4004_alternative-v2.txt
        15 kB
        Sylvain Lebresne
      3. 4004_alternative.txt
        14 kB
        Sylvain Lebresne

        Issue Links

          Activity

            People

            • Assignee:
              Sylvain Lebresne
              Reporter:
              Sylvain Lebresne
              Reviewer:
              Jonathan Ellis
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development