# 0100C — dynamic_result_sets_returned

> PostgreSQL SQLSTATE 0100C names a warning for dynamic result sets returned; the fixed core scan provides no emitting path.
---

# 0100C — dynamic_result_sets_returned

## At a glance {#at-a-glance}

`0100C` names a warning-category dynamic-result-set condition. No resolved 18.6 core/contrib report group was found, so no server-side producer, result-set count, or message is confirmed.

<!-- BEGIN SQLSTATE FACTS: generated by scripts/generate.py; do not edit -->

| Field | Value |
| --- | --- |
| SQLSTATE | `0100C` |
| Condition | `dynamic_result_sets_returned` |
| Status | `active` |
| Known present by | `7.4` |
| Locked snapshots | `9.0.23, 9.1.24, 9.2.24, 9.3.25, 9.4.26, 9.5.25, 9.6.24, 10.23, 11.22, 12.22, 13.23, 14.24, 15.19, 16.15, 17.11, 18.6, 19beta3` |
| Macros | `ERRCODE_WARNING_DYNAMIC_RESULT_SETS_RETURNED` |
| Aliases | `—` |

<!-- source facts: data/errcodes/0100C.json -->
<!-- END SQLSTATE FACTS -->

## Meaning {#meaning}

The definition names dynamic result sets returned as a warning condition. The fixed source scan does not identify the producer or the result-set protocol.

## Messages and diagnostics {#messages}

No resolved 18.6 message variant was found. Preserve the producing routine or interface, result-set count/order, client API, and complete warning or notice diagnostics.

## Diagnosis {#diagnosis}

Identify whether the producer is a procedural or client interface that supports dynamic result sets. Do not treat multiple command results from an ordinary SQL batch as this condition without source or protocol evidence.

## Response {#response}

Consume or declare the result sets according to the identified interface contract, or adjust that contract deliberately. A generic transaction retry does not address result-set handling.

## Versions {#versions}

`0100C` is present from the locked 9.0.23 snapshot through 18.6 and 19 Beta 3, with `known_present_by` 7.4. This is catalogue evidence, not a confirmed 18.6 core emission path.

## Related {#related}

[`02001`](../02001/) names no additional dynamic result sets; [`01000`](../01000/) is the warning class; [`00000`](../00000/) is successful completion.

## Sources {#sources}

- [`errcodes.txt`](https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/utils/errcodes.txt#L85) — definition, SHA-256 `6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba`.
- [Structured evidence](../data/evidence/0100c.json) — fixed sources, message groups, and runtime boundary.