[Solved] Given the composite type and table:CREATE TYPE address AS (city text, zip integer);CREATE TABLE users (id serial, home address);What will the query return?SELECT (home).city FROM users WHERE id = 1; | PostgreSQL

PostgreSQL - Advanced Features

Given the composite type and table:

CREATE TYPE address AS (city text, zip integer);
CREATE TABLE users (id serial, home address);

What will the query return?
SELECT (home).city FROM users WHERE id = 1;

AAn error because you cannot access composite fields like this

BThe zip code of the home address for user with id 1

CThe entire home composite value as text

DThe city name stored in the home column for user with id 1

Step-by-Step Solution

Solution:

Step 1: Understand composite field access syntax
Using (home).city extracts the city field from the composite column home.
Step 2: Analyze the query result
The query selects city from home for user with id 1, so it returns that city name.
Final Answer:
The city name stored in the home column for user with id 1 -> Option D
Quick Check:
(column).field extracts field from composite [OK]

Quick Trick: Use (column).field to get composite field value [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Given the composite type and table: