Skip to main content
2 of 2
markup, link
Erwin Brandstetter
  • 182.2k
  • 28
  • 457
  • 620

Use:

SELECT (ctyp).f1 FROM tbl;

The parentheses are necessary to disambiguate tables from composite types as detailed in the manual on composite types.

Erwin Brandstetter
  • 182.2k
  • 28
  • 457
  • 620