How do I create a virtaul column?
A virtual column is accessible like any other column except that there is no
physical column associated with it (unless it's indexed). The data for the
column is derived from other columns in the table. For example, in a table
people, a persons name is the concatentation if their first, middle and
surnames.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
