> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# DO
export const InternalLink = ({version, path = "", children, ...props}) => {
let detectedVersion = version || "stable";
if (typeof window !== 'undefined' && !version) {
const match = window.location.pathname.match(/\/docs\/([^/]+)/);
if (match) {
detectedVersion = match[1];
}
}
const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
return
{children}
;
};
The `DO` statement defines a code block that executes PL/pgSQL syntax.
## Required privileges
* To define a `DO` block with a user-defined type, a user must have `USAGE` privilege on the user-defined type.
## Synopsis
## Parameters
| Parameter | Description |
| ------------------ | --------------------------- |
| `routine_body_str` | The body of the code block. |
## Examples
### Declare a variable in a `DO` block
The following example uses the PL/pgSQL `DECLARE` syntax to declare variables to use in the code block.
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
DO $$
DECLARE
x INT := 10;
y INT := 5;
result INT;
BEGIN
result := x + y;
RAISE NOTICE 'The sum of % and % is %', x, y, result;
END $$;
```
```
NOTICE: The sum of 10 and 5 is 15
DO
```
### Use a loop in a `DO` block
The following example uses the PL/pgSQL `WHILE` syntax to loop through several statements.
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
DO $$
DECLARE
counter INT := 1;
BEGIN
WHILE counter <= 5 LOOP
RAISE NOTICE 'Counter: %', counter;
counter := counter + 1;
END LOOP;
END $$;
```
```
NOTICE: Counter: 1
NOTICE: Counter: 2
NOTICE: Counter: 3
NOTICE: Counter: 4
NOTICE: Counter: 5
DO
```
### Use a common table expression in a `DO` block
The following example uses a common table expression in the body of the code block.
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
DO $$
DECLARE
sum_result INT;
BEGIN
WITH numbers AS (
SELECT generate_series(1, 5) AS num
)
SELECT sum(num) INTO sum_result
FROM numbers;
RAISE NOTICE 'Sum of numbers 1-5: %', sum_result;
END $$;
```
```
NOTICE: Sum of numbers 1-5: 15
DO
```
## See also
* PL/pgSQL
* Stored Procedures
* User-Defined Functions