|< < 9 > >|

Duplicates

Digression: Metadata of query results

Example 2

jao=# select x from dups_ok; x ----- 100 100 (2 rows)
  • Query result names the column to match the table.
jao=# select x + 0 from dups_ok; ?column? ------------ 100 100 (2 rows)
  • Query result does not preserve the column name.

|< < 9 > >|