Postmodern Examples Table of Contents
[Special Characters][A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

sql-op :+, :*, :%, :&, :|, :||, :=, :/, :!=, :<, :<>, :>, :<=, :>=, :^, *, /, , <>, and, any, as, avg, between, casecoalesce, commit, constraints, count, current-date, current-timestamp, datatypes, date-part,date-trunc,desc, distinct, distinct-on, except, :except-all exists, group-by, having, in, insert, :intersect, :intersect-all, is-null, join cross-join, join inner-join, join left-join, join outer-join, like, limit, not,now, null, on, or, order-by, raw, rollback, select, set, some, sum, transactions, truncate, union, union-all, unique, update, using, when, while

Many to Many Calls

Many database records are linked in a many to many relationship with other tables or records. Consider the following query:

(query "select,, as event from countries,events,countries_events where and and")

This can be rephrased in s-sql as:

(query (:select ' ' (:as ' 'event ) :from 'countries 'events 'countries_events :where (:and (:= 'country_id ' (:= ' 'event_id) (:= ' '$1))) 29)