|
632.
|
|
|
define a new savepoint within the current transaction
|
|
|
|
definisci un nuovo punto di salvataggio per la transazione corrente
|
|
Translated by
Daniele Varrazzo
|
|
|
|
Located in
sql_help.h:517
|
|
633.
|
|
|
SAVEPOINT savepoint_name
|
|
|
|
SAVEPOINT savepoint_name
|
|
Translated by
Daniele Varrazzo
|
|
|
|
Located in
sql_help.h:518
|
|
634.
|
|
|
retrieve rows from a table or view
|
|
|
|
estrai righe da una tabella o una vista
|
|
Translated by
Gabriele Bartolini
|
|
|
|
Located in
sql_help.h:521 sql_help.h:557 sql_help.h:581
|
|
635.
|
|
|
[ WITH [ RECURSIVE ] with_query [, ...] ] ![](/@@/translation-newline)
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
* | expression [ [ AS ] output_name ] [, ...]
[ FROM from_item [, ...] ]
[ WHERE condition ]
[ GROUP BY expression [, ...] ]
[ HAVING condition [, ...] ]
[ WINDOW window_name AS ( window_definition ) [, ...] ]
[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
[ ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] ]
[ LIMIT { count | ALL } ]
[ OFFSET start [ ROW | ROWS ] ]
[ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]
[ FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT ] [...] ]
![](/@@/translation-newline)
where from_item can be one of:
[ ONLY ] table_name [ * ] [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
( select ) [ AS ] alias [ ( column_alias [, ...] ) ]
with_query_name [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
function_name ( [ argument [, ...] ] ) [ AS ] alias [ ( column_alias [, ...] | column_definition [, ...] ) ]
function_name ( [ argument [, ...] ] ) AS ( column_definition [, ...] )
from_item [ NATURAL ] join_type from_item [ ON join_condition | USING ( join_column [, ...] ) ]
![](/@@/translation-newline)
and with_query is:
with_query_name [ ( column_name [, ...] ) ] AS ( select )
![](/@@/translation-newline)
TABLE { [ ONLY ] table_name [ * ] | with_query_name }
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
[ WITH [ RECURSIVE ] with_query [, ...] ] ![](/@@/translation-newline)
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
* | expression [ [ AS ] output_name ] [, ...]
[ FROM from_item [, ...] ]
[ WHERE condition ]
[ GROUP BY expression [, ...] ]
[ HAVING condition [, ...] ]
[ WINDOW window_name AS ( window_definition ) [, ...] ]
[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
[ ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] ]
[ LIMIT { count | ALL } ]
[ OFFSET start [ ROW | ROWS ] ]
[ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]
[ FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT ] [...] ]
![](/@@/translation-newline)
dove from_item può essere uno di:
[ ONLY ] table_name [ * ] [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
( select ) [ AS ] alias [ ( column_alias [, ...] ) ]
with_query_name [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
function_name ( [ argument [, ...] ] ) [ AS ] alias [ ( column_alias [, ...] | column_definition [, ...] ) ]
function_name ( [ argument [, ...] ] ) AS ( column_definition [, ...] )
from_item [ NATURAL ] join_type from_item [ ON join_condition | USING ( join_column [, ...] ) ]
![](/@@/translation-newline)
e with_query è:
with_query_name [ ( column_name [, ...] ) ] AS ( select )
![](/@@/translation-newline)
TABLE { [ ONLY ] table_name [ * ] | with_query_name }
|
|
Translated by
Daniele Varrazzo
|
|
|
|
Located in
sql_help.h:522 sql_help.h:558 sql_help.h:582
|
|
636.
|
|
|
[ WITH [ RECURSIVE ] with_query [, ...] ] ![](/@@/translation-newline)
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
* | expression [ [ AS ] output_name ] [, ...]
INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table
[ FROM from_item [, ...] ]
[ WHERE condition ]
[ GROUP BY expression [, ...] ]
[ HAVING condition [, ...] ]
[ WINDOW window_name AS ( window_definition ) [, ...] ]
[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
[ ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] ]
[ LIMIT { count | ALL } ]
[ OFFSET start [ ROW | ROWS ] ]
[ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]
[ FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT ] [...] ]
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
[ WITH [ RECURSIVE ] with_query [, ...] ] ![](/@@/translation-newline)
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
* | expression [ [ AS ] output_name ] [, ...]
INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table
[ FROM from_item [, ...] ]
[ WHERE condition ]
[ GROUP BY expression [, ...] ]
[ HAVING condition [, ...] ]
[ WINDOW window_name AS ( window_definition ) [, ...] ]
[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
[ ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] ]
[ LIMIT { count | ALL } ]
[ OFFSET start [ ROW | ROWS ] ]
[ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]
[ FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT ] [...] ]
|
|
Translated by
Daniele Varrazzo
|
|
|
|
Located in
sql_help.h:526
|
|
637.
|
|
|
change a run-time parameter
|
|
|
|
modifica un parametro di esecuzione
|
|
Translated by
Daniele Varrazzo
|
|
|
|
Located in
sql_help.h:529
|
|
638.
|
|
|
SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value | 'value' | DEFAULT } ![](/@@/translation-newline)
SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT }
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value | 'value' | DEFAULT } ![](/@@/translation-newline)
SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT }
|
|
Translated by
Daniele Varrazzo
|
|
|
|
Located in
sql_help.h:530
|
|
639.
|
|
|
set constraint checking modes for the current transaction
|
|
|
|
imposta la modalità di controllo dei vincoli per la transazione corrente
|
|
Translated by
Daniele Varrazzo
|
|
|
|
Located in
sql_help.h:533
|
|
640.
|
|
|
SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE }
|
|
|
|
SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE }
|
|
Translated by
Daniele Varrazzo
|
|
|
|
Located in
sql_help.h:534
|
|
641.
|
|
|
set the current user identifier of the current session
|
|
|
|
imposta l'identificativo utente della sessione corrente
|
|
Translated by
Daniele Varrazzo
|
|
|
|
Located in
sql_help.h:537
|