A.5. SELECT and UPDATE Syntax
The next two sections give a brief introduction to the two SQL commands implemented by the RTA API. Neither the RTA UPDATE command nor the RTA SELECT command adhere strictly to their PostgreSQL equivalents. RTA does not allow JOIN clauses, and the WHERE clause supports only the boolean AND operator. There are no locks or transactions.
A.5.1. The SELECT Command
The prototype for the RTA SELECT command is shown below.
SELECT column_list FROM table [where_clause] [limit_clause]
Most NCMDCOLS (defined above) columns can be specified in the column_list or in the WHERE clause. The reserved word LIMIT restricts the number of rows returned to the number specified. The reserved word OFFSET skips the number of rows specified ...
Get Linux Appliance Design now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
