.........................................................................................519 31-4. R-tree Strategies ................................................................................... .........................................................................................521 31-7. R-tree Support Functions............................................................................. that C-style backslash escapes are available: \b is a backspace, \f is a form feed, \n is a newline, \r is a carriage return, \t is a tab, and \xxx, where xxx is an octal number, is a byte with the corresponding

.........................................................................................491 31-4. R-tree Strategies ................................................................................... .........................................................................................492 31-7. R-tree Support Functions............................................................................. that C-style backslash escapes are available: \b is a backspace, \f is a form feed, \n is a newline, \r is a carriage return, \t is a tab, and \xxx, where xxx is an octal number, is a byte with the corresponding

.........................................................................................557 32-4. R-tree Strategies ................................................................................... .........................................................................................559 32-7. R-tree Support Functions............................................................................. that C-style backslash escapes are available: \b is a backspace, \f is a form feed, \n is a newline, \r is a carriage return, \t is a tab. Also supported is \digits, where digits represents an octal byte

.........................................................................................560 32-4. R-tree Strategies ................................................................................... .........................................................................................562 32-7. R-tree Support Functions............................................................................. that C-style backslash escapes are available: \b is a backspace, \f is a form feed, \n is a newline, \r is a carriage return, \t is a tab. Also supported is \digits, where digits represents an octal byte

................................................................. 1135 37.4. GiST Two-Dimensional “R-tree” Strategies ........................................................... 1135 37.5. SP-GiST Point Escape Sequences Backslash Escape Sequence Interpretation \b backspace \f form feed \n newline \r carriage return \t tab \o, \oo, \ooo (o = 0 - 7) octal byte value \xh, \xhh (h = 0 - 9, A - F) hexadecimal $function$ BEGIN RETURN ($1 ~ $q$[\t\r\n\v\\]$q$); 37 SQL Syntax END; $function$ Here, the sequence $q$[\t\r\n\v\\]$q$ represents a dollar-quoted literal string [\t\r\n\v \\], which will be recognized

Escape Sequences Backslash Escape Sequence Interpretation \b backspace \f form feed \n newline \r carriage return \t tab \o, \oo, \ooo (o = 0 - 7) octal byte value \xh, \xhh (h = 0 - 9, A - F) hexadecimal example: $function$ BEGIN RETURN ($1 ~ $q$[\t\r\n\v\\]$q$); END; $function$ Here, the sequence $q$[\t\r\n\v\\]$q$ represents a dollar-quoted literal string [\t\r\n\v\\], which will be recognized when the types of qualified join are: INNER JOIN For each row R1 of T1, the joined table has a row for each row in T2 that satisfies the join condition with R1. LEFT OUTER JOIN First, an inner join is performed

................................................................. 1195 37.4. GiST Two-Dimensional “R-tree” Strategies ................................................................ 1196 37.5. SP-GiST Escape Sequences Backslash Escape Sequence Interpretation \b backspace \f form feed \n newline \r carriage return \t tab \o, \oo, \ooo (o = 0 - 7) octal byte value \xh, \xhh (h = 0 - 9, A - F) hexadecimal $function$ BEGIN RETURN ($1 ~ $q$[\t\r\n\v\\]$q$); END; $function$ Here, the sequence $q$[\t\r\n\v\\]$q$ represents a dollar-quoted literal string [\t\r\n\v\\], which will be recognized when the

Escape Sequences Backslash Escape Sequence Interpretation \b backspace \f form feed \n newline \r carriage return \t tab \o, \oo, \ooo (o = 0 - 7) octal byte value \xh, \xhh (h = 0 - 9, A - F) hexadecimal example: $function$ BEGIN RETURN ($1 ~ $q$[\t\r\n\v\\]$q$); END; $function$ Here, the sequence $q$[\t\r\n\v\\]$q$ represents a dollar-quoted literal string [\t\r\n\v\\], which will be recognized when the types of qualified join are: INNER JOIN For each row R1 of T1, the joined table has a row for each row in T2 that satisfies the join condition with R1. LEFT OUTER JOIN First, an inner join is performed

Escape Sequences Backslash Escape Sequence Interpretation \b backspace \f form feed \n newline \r carriage return \t tab \o, \oo, \ooo (o = 0 - 7) octal byte value \xh, \xhh (h = 0 - 9, A - F) hexadecimal example: $function$ BEGIN RETURN ($1 ~ $q$[\t\r\n\v\\]$q$); END; $function$ Here, the sequence $q$[\t\r\n\v\\]$q$ represents a dollar-quoted literal string [\t\r\n\v\\], which will be recognized when the types of qualified join are: INNER JOIN For each row R1 of T1, the joined table has a row for each row in T2 that satisfies the join condition with R1. LEFT OUTER JOIN First, an inner join is performed

Escape Sequences Backslash Escape Sequence Interpretation \b backspace \f form feed \n newline \r carriage return \t tab \o, \oo, \ooo (o = 0 - 7) octal byte value \xh, \xhh (h = 0 - 9, A - F) hexadecimal example: $function$ BEGIN RETURN ($1 ~ $q$[\t\r\n\v\\]$q$); END; $function$ Here, the sequence $q$[\t\r\n\v\\]$q$ represents a dollar-quoted literal string [\t\r\n\v\\], which will be recognized when the types of qualified join are: INNER JOIN For each row R1 of T1, the joined table has a row for each row in T2 that satisfies the join condition with R1. LEFT OUTER JOIN First, an inner join is performed