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
30 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

    Returns EVM event logs matching the supplied emitter, block, and topic filters. Supply a human-readable event signature or JSON ABI to append typed decoded fields.

    table function Live RPC RPC 12 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
  • 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 exact EVM runtime bytecode used to evaluate a PROGRAM offline.

    scalar function Offline 1 overload
  • assume_native_balance

    Declares an exact native-token balance used to evaluate a PROGRAM offline.

    scalar function Offline 1 overload
  • assume_no_code

    Declares that an account has no EVM runtime bytecode.

    scalar function Offline 1 overload
  • assume_nonce

    Declares an exact account nonce used to evaluate a PROGRAM offline.

    scalar function Offline 1 overload
  • assume_storage

    Declares an exact contract storage-slot value used to evaluate a PROGRAM offline.

    scalar function Offline 1 overload
  • code_at

    Returns deployed bytecode for an address 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
  • evm_abi_word

    Encodes a supported scalar as exactly one 32-byte Solidity ABI word. Addresses and unsigned integers are left-padded; signed integers are sign-extended.

    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 sequential, non-atomic PROGRAM execution.

    scalar function Offline 2 overloads
  • execute_contract

    Builds one ABI-encoded contract call step for sequential, 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

    Labels an address without reading state.

    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 ABI-decoded SQL values. 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 historical block 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

Returned as output

  • get_block

    Returns block metadata for a block number, tag, or hash. Set include_transactions to request expanded transaction objects in transactions_full; otherwise transactions contains hashes.

    table function Live RPC RPC 5 overloads
  • get_transaction

    Returns transaction fields and available receipt metadata for a transaction hash. The client must point to the chain where the transaction exists.

    table function Live RPC RPC 2 overloads