ADDRESS

20-byte Ethereum address stored as raw bytes. 0x-prefixed VARCHAR casts parse exact hex; VARCHAR output is hex for display. In Solidity ABI words, ADDRESS values are left-padded to 32 bytes.

Family
Address
Physical
BLOB
Used by
32 functions
Examples
0 samples

Used by functions

Derived from generated function parameters and return types.

Input and output

  • create_access_list

    Builds an EIP-2930 access list for a transaction request. Each result row identifies an accessed account or storage slot and includes request status.

    table function Live RPC RPC 3 overloads
  • create2_mine

    Scans a bounded local CPU salt range for EIP-1014 CREATE2 addresses. It performs no network I/O, deployment, chain-state lookup, collision check, or vanity-address safety proof.

    table function Offline 2 overloads
  • create2_predict

    Computes the EIP-1014 CREATE2 address from the executing deployer, exact salt, and complete init-code hash. This is deterministic local arithmetic and does not query or mutate chain state.

    scalar function Offline 2 overloads
  • get_logs

    Reads logs matching emitter, inclusive block bounds, and topic filters. Live clients use eth_getLogs; retained execution clients read stored execution logs.

    table function Live RPC RPC 12 overloads
  • read_contract_multicall

    Executes a table of encoded contract reads through Multicall3 and returns one diagnostic row per input call. Results separately report batch execution and target-call success.

    table function Live RPC RPC 1 overload

Accepted as input

  • assume_code

    Declares the exact EVM runtime bytecode supplied for one address in a PROGRAM's initial state.

    scalar function Offline 1 overload
  • assume_native_balance

    Declares the exact native balance, in Wei, supplied for one address in a PROGRAM's initial state.

    scalar function Offline 1 overload
  • assume_no_code

    Declares that one address has no EVM runtime bytecode in a PROGRAM's initial state.

    scalar function Offline 1 overload
  • assume_nonce

    Declares the exact account nonce supplied for one address in a PROGRAM's initial state.

    scalar function Offline 1 overload
  • assume_storage

    Declares the exact 32-byte value supplied for one contract storage slot in a PROGRAM's initial state.

    scalar function Offline 1 overload
  • code_at

    Reads an account's runtime bytecode from live RPC state, the exact state identified by a pinned CLIENT, or retained execution state. Without a CLIENT, it builds a reusable READ and does not access state.

    scalar function Live RPC RPC 4 overloads
  • evm_abi_word

    Encodes an ADDRESS, BYTES32, BOOLEAN, or integer as one 32-byte Solidity ABI word. ADDRESS and unsigned integer values are left-padded with zeros. Signed integers are sign-extended in two's-complement form; BOOLEAN uses 0 or 1. BYTES32 values are copied unchanged.

    scalar function Offline 1 overload
  • evm_decode_log_for

    Returns a log diagnostic using the ABI registered locally for a chain, emitter, and block; use it when ABI selection depends on contract context.

    scalar function Offline 1 overload
  • evm_decode_revert_for

    Returns a revert diagnostic using the ABI registered locally for a chain, contract, and block; use it when ABI selection depends on contract context.

    scalar function Offline 1 overload
  • evm_register_contract_abi

    Stores contract ABI metadata in the current database for block-aware log and revert decoding.

    scalar function Offline 4 overloads
  • execute_call

    Builds one raw EVM call step for ordered, non-atomic PROGRAM execution.

    scalar function Offline 2 overloads
  • execute_contract

    Selects an ABI function, encodes its arguments, and builds one step for ordered, non-atomic PROGRAM execution.

    scalar function Offline 2 overloads
  • hex

    Formats a BLOB-backed EVM byte value as uppercase hexadecimal text without a 0x prefix. hex and to_hex are compatibility aliases with identical behavior.

    scalar function Offline 1 overload
  • length

    Returns the number of bytes in a BLOB or BLOB-backed EVM value such as ADDRESS, BYTES32, UINT256, or INT256.

    scalar function Offline 1 overload
  • native_balance

    Returns an address's native-token balance as exact Wei in live, pinned, or retained execution state. Without a CLIENT, it builds a reusable READ and does not access state.

    scalar function Live RPC RPC 3 overloads
  • nonce

    Returns an address's transaction count in live, pinned, or retained execution state. Without a CLIENT, it builds a reusable READ and does not access state.

    scalar function Live RPC RPC 3 overloads
  • observation_fact

    Declares a human-readable label for an address without scheduling a READ.

    scalar function Offline 1 overload
  • raw_call

    Executes an isolated EVM call and returns the raw response bytes. Without a CLIENT, it builds a reusable READ and does not execute the call.

    scalar function Live RPC RPC 4 overloads
  • read_contract

    Calls a contract function against live, pinned, or retained execution state and returns a typed SQL value. Without a CLIENT, it builds a reusable READ and does not execute the call.

    scalar function Live RPC RPC 4 overloads
  • read_contract_at

    Calls a contract function at an explicit block number and returns ABI-decoded SQL values.

    scalar function Live RPC RPC 1 overload
  • storage_at

    Returns one raw 32-byte storage word for a contract and BYTES32 slot in live, pinned, or retained execution state. Without a CLIENT, it builds a reusable READ and does not access state.

    scalar function Live RPC RPC 3 overloads
  • to_hex

    Formats a BLOB-backed EVM byte value as uppercase hexadecimal text without a 0x prefix. hex and to_hex are compatibility aliases with identical behavior.

    scalar function Offline 1 overload
  • try_native_balance

    Returns an address's native-token balance as exact Wei at an explicit block, as native_balance does. A balance read cannot revert, so a failed read raises here too.

    scalar function Offline 1 overload
  • try_read_contract_at

    Calls a contract function at an explicit block number like read_contract_at; a revert, an address without code or an undecodable return gives NULL instead of an error. A transport, rate-limit or archive failure raises.

    scalar function Live RPC RPC 1 overload

Returned as output

  • get_block

    Fetches a block by decimal height, supported block tag, or block hash. The block defaults to latest and include_transactions defaults to false.

    table function Live RPC RPC 5 overloads
  • get_transaction

    Fetches a transaction by hash, then makes a separate receipt request for receipt metadata.

    table function Live RPC RPC 2 overloads
  • get_transaction_logs

    Returns logs from a transaction receipt, optionally filtered by emitter or indexed topics. Supply an event signature or JSON ABI to append typed decoded fields.

    table function Live RPC RPC 6 overloads