Skip to content

PeachQ

Try Live Download Docs Compatibility News About GitHub ↗

Initializing search

PeachQ

GitHub

Docs
Docs
- Getting started
- q language reference
  q language reference
  - Language basics
    Language basics
    
    Application, projection, and indexing
    
    Atomic functions
    
    Q language resources by topic
    
    Command line options
    
    Comparison
    
    Conformable data objects
    
    Controlling evaluation
    
    Datatypes
    
    Debugging
    
    Dictionaries
    
    Enumerations
    
    Errors
    
    Exposed infrastructure
    
    File system
    
    Function notation
    
    Functional qSQL
    
    Glossary
    
    Connection handles
    
    Implicit iteration
    
    Internal functions
    
    Interprocess communication
    
    Iteration
    
    Joins
    
    Listening port
    
    Mathematics and statistics
    
    Metadata
    
    Namespaces
    
    Parse trees
    
    Pattern Matching
    
    Parallel processing
    
    Precision
    
    QSQL query templates
    
    Regular expressions
    
    Syntax
    
    System commands
    
    Variadic syntax
  - Functions and operators
    Functions and operators
    
    abs
    
    Accumulators
    
    + Add
    
    aj, aj0, ajf, ajf0
    
    all, any
    
    . @ Amend, Amend At
    
    and
    
    . Apply, Index, Trap@ Apply At, Index At, Trap At
    
    asc, iasc, xasc
    
    asof
    
    Assign
    
    attr
    
    avg, avgs, mavg, wavg
    
    bin, binr
    
    $ Cast
    
    ceiling
    
    ^ Coalesce
    
    cols, xcol, xcols
    
    ' Compose
    
    $ Cond
    
    cor
    
    cos, acos
    
    count, mcount
    
    cov, scov
    
    cross
    
    csv
    
    _ Cut, cut
    
    ? Roll, Deal, Permute
    
    delete
    
    deltas
    
    desc, idesc, xdesc
    
    dev, mdev, sdev
    
    ! Dict
    
    differ
    
    ! Display
    
    distinct
    
    div
    
    % Divide
    
    do
    
    The .h namespace
    
    The .j namespace
    
    The .m namespace
    
    The .Q namespace
    
    The .z namespace
    
    _ Drop
    
    dsave
    
    2: Dynamic Load
    
    each, peach
    
    ej
    
    ema
    
    ! Enkey, Unkey
    
    enlist
    
    ? Enum Extend
    
    $ Enumerate
    
    ! Enumeration
    
    = Equal
    
    eval, reval
    
    except
    
    exec
    
    exit
    
    exp, xexp
    
    fby
    
    1: File Binary
    
    0: File Text
    
    ^ Fill, fills
    
    ? Find
    
    first, last
    
    fkeys
    
    ! Flip Splayed or Partitioned
    
    flip
    
    floor
    
    get, set
    
    getenv
    
    > Greater Than >= At Least
    
    | Greater, or
    
    group
    
    gtime, ltime
    
    hcount
    
    hdel
    
    hopen, hclose
    
    hsym
    
    Identity, Null
    
    if
    
    ij, ijf
    
    in
    
    insert
    
    inter
    
    inv
    
    Iterators
    
    , ,: Join and Append
    
    key
    
    keys, xkey
    
    <= Up To
    
    & Lesser, and
    
    like
    
    lj, ljf
    
    load, rload
    
    log, xlog
    
    lower, upper
    
    lsq
    
    Map iterators
    
    ~ Match
    
    max, maxs, mmax
    
    md5
    
    med
    
    meta
    
    min, mins, mmin
    
    $ Matrix Multiply, mmu
    
    mod
    
    Multiply
    
    neg
    
    next, prev, xprev
    
    <> Not Equal
    
    not
    
    null
    
    or
    
    over, scan
    
    Overloaded glyphs
    
    $ Pad
    
    parse
    
    pj
    
    prd, prds
    
    prior
    
    rand
    
    rank
    
    ratios
    
    raze
    
    read0
    
    read1
    
    reciprocal
    
    reverse
    
    rotate
    
    save, rsave
    
    select
    
    # Set Attribute
    
    show
    
    ' Signal
    
    signum
    
    ? Simple Exec
    
    sin, asin
    
    sqrt
    
    ss, ssr
    
    string
    
    sublist
    
    - Subtract
    
    sum, sums, msum, wsum
    
    sv
    
    system
    
    tables
    
    # Take
    
    tan, atan
    
    til
    
    $ Tok
    
    trim, ltrim, rtrim
    
    type
    
    uj, ujf
    
    ungroup
    
    union
    
    update
    
    upsert
    
    value
    
    var, svar
    
    ? Vector Conditional
    
    view, views
    
    vs
    
    where
    
    while
    
    within
    
    wj, wj1
    
    xbar
    
    xgroup
    
    xrank
- PeachQ additions and differences
  PeachQ additions and differences
- Library API
News
Thanks

`?` Simple Exec¶

For functional Simple Exec, see Basics: Functional qSQL

PeachQ - MIT-licensed open source q, built on Rayforce with DuckDB storage in progress. Thanks

Try Live Download Docs Compatibility Roadmap News About Contact GitHub ↗

? Simple Exec¶

`?` Simple Exec¶