[Solved] Find the error in this query:SELECT info.city FROM users;Given that info is a composite type column with fields city and zip. | PostgreSQL

PostgreSQL - Advanced Features

Find the error in this query:
SELECT info.city FROM users;
Given that info is a composite type column with fields city and zip.

AField city does not exist in composite type

BQuery missing WHERE clause

CComposite types cannot be queried directly

DMissing parentheses around composite column when accessing field

Step-by-Step Solution

Solution:

Step 1: Recall syntax for accessing composite fields
Must use parentheses: (info).city to access field city.
Step 2: Identify syntax error
info.city without parentheses causes syntax error.
Final Answer:
Missing parentheses around composite column when accessing field -> Option D
Quick Check:
Access composite fields with (column).field [OK]

Quick Trick: Always use parentheses when accessing composite fields [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Find the error in this query: