Debian Codegraph @

tests/inputs/ranges.surql

raw
1 /*
2 https://surrealdb.com/docs/surrealql/statements/select#example-usage
3 */
4 -- Select all person records with IDs between the given range
5 SELECT * FROM person:1..1000;
6 # Select all records for a particular location, inclusive
7 SELECT * FROM temperature:['London', NONE]..=['London', time::now()];
8 -- Select all temperature records with IDs less than a maximum value
9 SELECT * FROM temperature:..['London', '2022-08-29T08:09:31'];
10 -- Select all temperature records with IDs greater than a minimum value
11 SELECT * FROM temperature:['London', '2022-08-29T08:03:39']..;
12 -- Select all temperature records with IDs between the specified range
13 SELECT * FROM temperature:['London', '2022-08-29T08:03:39']..['London', '2022-08-29T08:09:31'];