Skip to main content
Database Administrators

Return to Answer

markup, link
Source Link
Erwin Brandstetter
Erwin Brandstetter
  • 182.2k
  • 28
  • 457
  • 620

Use:

SELECT (ctyp).f1 FROM tbl;SELECT (ctyp).f1 FROM tbl;

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

Use:

SELECT (ctyp).f1 FROM tbl;

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

Use:

SELECT (ctyp).f1 FROM tbl;

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

Source Link
Erwin Brandstetter
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.