Example selection based on part of an object
Use this example to orient yourself when retrieving records from tables based on criteria that apply to parts of a table row.
The following example retrieves records from the staff.contractors table
where Department="Operations" within the ExtraInfo column.
|phoenix:1.> select Name, Age from staff.employees
|phoenix:2.> where ExtraInfo->Department="Operations";
|phoenix:3.> go
..
{
Name='Richard';
Age=23;
}
{
Name='Glenn';
Age=28;
}
( 2 record(s) : Transaction complete )