column set must be specified in the calling query so that the parser knows, for example, what * should expand to. This example uses ROWS FROM: SELECT * FROM ROWS FROM ( json_to_recordset('[{"a":40 not XQuery. • XQuery's x (ignore whitespace in pattern) flag is noticeably different from POSIX's expand- ed-mode flag. POSIX's x flag also allows # to begin a comment in the pattern, and POSIX will not unnest(tsvec- tor, OUT lex- eme text, OUT posi- tions small- int[], OUT weights text) setof record expand a tsvec- tor to a set of rows unnest('fat:2,4 cat:3 rat:5A'::tsvec- tor) (cat,{3}, {D}) ... Note

column set must be specified in the calling query so that the parser knows, for example, what * should expand to. This example uses ROWS FROM: SELECT * FROM ROWS FROM ( json_to_recordset('[{"a":40 unnest(tsvec- tor, OUT lex- eme text, OUT posi- tions small- int[], OUT weights text) setof record expand a tsvec- tor to a set of rows unnest('fat:2,4 cat:3 rat:5A'::tsvec- tor) (cat,{3}, {D}) ... Note setof anyele- ment expand an array to a set of rows unnest(AR- RAY[1,2]) 1 2 (2 rows) unnest(an- yarray, an- yarray [, ...]) setof anyele- ment, anyele- ment [, ...] expand multiple ar- rays (possibly

column set must be specified in the calling query so that the parser knows, for example, what * should expand to. This example uses ROWS FROM: SELECT * FROM ROWS FROM ( json_to_recordset('[{"a":40 unnest(tsvec- tor, OUT lex- eme text, OUT posi- tions small- int[], OUT weights text) setof record expand a tsvec- tor to a set of rows unnest('fat:2,4 cat:3 rat:5A'::tsvec- tor) (cat,{3}, {D}) ... Note setof anyele- ment expand an array to a set of rows unnest(AR- RAY[1,2]) 1 2 (2 rows) unnest(an- yarray, an- yarray [, ...]) setof anyele- ment, anyele- ment [, ...] expand multiple arrays (possibly

column set must be specified in the calling query so that the parser knows, for example, what * should expand to. This example uses ROWS FROM: SELECT * FROM ROWS FROM ( json_to_recordset('[{"a":40 ger_colum- n(tsvcol, configcol, title, body) unnest(tsvec- tor, OUT lex- eme text, setof record expand a tsvec- tor to a set of rows unnest('fat:2,4 cat:3 rat:5A'::tsvec- tor) (cat,{3}, {D}) ... 275 setof anyele- ment expand an array to a set of rows unnest(AR- RAY[1,2]) 1 2 (2 rows) unnest(an- yarray, an- yarray [, ...]) setof anyele- ment, anyele- ment [, ...] expand multiple arrays (possibly

column set must be specified in the calling query so that the parser knows, for example, what * should expand to. This example uses ROWS FROM: SELECT * FROM ROWS FROM ( json_to_recordset('[{"a":40 not XQuery. • XQuery's x (ignore whitespace in pattern) flag is noticeably different from POSIX's expand- ed-mode flag. POSIX's x flag also allows # to begin a comment in the pattern, and POSIX will not rewrite rule. A collection of such rewrite rules can be a powerful search aid. For example, you can expand the search using synonyms (e.g., new york, big apple, nyc, gotham) or narrow the search to direct

column set must be specified in the calling query so that the parser knows, for example, what * should expand to. 7.2.2. The WHERE Clause The syntax of the WHERE Clause is WHERE search_condition where search_condition and Operators Function Return Type Description Example Result unnest(anyarray) setof anyelement expand an array to a set of rows unnest(ARRAY[1,2]) 1 2 (2 rows) In string_to_array, if the delimiter rewrite rule. A collection of such rewrite rules can be a powerful search aid. For example, you can expand the search using synonyms (e.g., new york, big apple, nyc, gotham) or narrow the search to direct

column set must be specified in the calling query so that the parser knows, for example, what * should expand to. 97 Chapter 7. Queries 7.2.2. The WHERE Clause The syntax of the WHERE Clause is WHERE search_condition string_to_array(’xx~^~yy~^~zz’, ’~^~’, ’yy’) {xx,NULL,zz} unnest(anyarray) setof anyelement expand an array to a set of rows unnest(ARRAY[1,2]) 1 2 (2 rows) In string_to_array, if the delimiter rewrite rule. A collection of such rewrite rules can be a powerful search aid. For example, you can expand the search using synonyms (e.g., new york, big apple, nyc, gotham) or narrow the search to direct

column set must be specified in the calling query so that the parser knows, for example, what * should expand to. This example uses ROWS FROM: SELECT * FROM ROWS FROM ( json_to_recordset('[{"a":40 rewrite rule. A collection of such rewrite rules can be a powerful search aid. For example, you can expand the search using synonyms (e.g., new york, big apple, nyc, gotham) or narrow the search to direct source query to ORDER BY some ordering key. Let's consider a real-life astronomical example. We'll expand query supernovae using table-driven rewriting rules: CREATE TABLE aliases (t tsquery primary key

column set must be specified in the calling query so that the parser knows, for example, what * should expand to. 7.2.1.5. LATERAL Subqueries Subqueries appearing in FROM can be preceded by the key word LATERAL string_to_array(’xx~^~yy~^~zz’, ’~^~’, ’yy’) {xx,NULL,zz} unnest(anyarray) setof anyelement expand an array to a set of rows unnest(ARRAY[1,2]) 1 2 (2 rows) In string_to_array, if the delimiter rewrite rule. A collection of such rewrite rules can be a powerful search aid. For example, you can expand the search using synonyms (e.g., new york, big apple, nyc, gotham) or narrow the search to direct

column set must be specified in the calling query so that the parser knows, for example, what * should expand to. This example uses ROWS FROM: SELECT * FROM ROWS FROM ( json_to_recordset('[{"a":40 not XQuery. • XQuery's x (ignore whitespace in pattern) flag is noticeably different from POSIX's expand- ed-mode flag. POSIX's x flag also allows # to begin a comment in the pattern, and POSIX will not rewrite rule. A collection of such rewrite rules can be a powerful search aid. For example, you can expand the search using synonyms (e.g., new york, big apple, nyc, gotham) or narrow the search to direct