Input of anonymous composite types is not implemented

The error message “input of anonymous composite types is not implemented” indicates that the system or software you are using does not support entering or using anonymous composite types.

Anonymous composite types refer to data structures that do not have a predefined or named type. They consist of multiple fields or attributes grouped together without explicitly defining a type for them. For example, consider the following composite type:

    
      {name: "John Doe", age: 30}
    
  

In this example, the composite type has two attributes: name and age. However, there is no specific type defined for this composite type.

Some systems or databases may not support directly working with anonymous composite types because they require a predefined schema or structure to store and manipulate data efficiently. In such cases, you may need to define a named composite type with a specific schema before using it.

To illustrate, let’s assume you are working with a PostgreSQL database that does not support anonymous composite types. You can define a named composite type like this:

    
      CREATE TYPE person_type AS (
        name text,
        age integer
      );
    
  

Now you can use the defined person_type to declare variables, create tables, or perform operations on data that follow this specific schema:

    
      DECLARE
        person person_type;
        
      BEGIN
        person.name := 'John Doe';
        person.age := 30;
      
        -- Perform operations using person variable
      
      END;
    
  

By using a named composite type, you can ensure the system understands the structure and type of the data you are working with.