interval value to (or subtracting an interval value from) a timestamp with time zone value, the days component advances (or decrements) the date of the timestamp with time zone by the indicated number of days negative values to zones west of UTC. timezone_hour The hour component of the time zone offset timezone_minute The minute component of the time zone offset week The number of the week of the year polygon(path) polygon path to polygon polygon(path ’((0,0),(1,1),(2,0))’) It is possible to access the two component numbers of a point as though it were an array with indices 0 and 1. For example, if t.p is a point

should store XML documents in ordinary TEXT fields. If you need the document split apart into its component parts so each element is stored separately, you must use a middle-ware solution to do that, but interval value to (or subtracting an interval value from) a timestamp with time zone value, the days component advances (or decrements) the date of the timestamp with time zone by the indicated number of days negative values to zones west of UTC. timezone_hour The hour component of the time zone offset timezone_minute The minute component of the time zone offset week The number of the week of the year

should store XML documents in ordinary TEXT fields. If you need the document split apart into its component parts so each element 129 Chapter 8. Data Types is stored separately, you must use a middle-ware interval value to (or subtracting an interval value from) a timestamp with time zone value, the days component advances (or decrements) the date of the timestamp with time zone by the indicated number of days negative values to zones west of UTC. timezone_hour The hour component of the time zone offset timezone_minute The minute component of the time zone offset week The number of the week of the year

interval value to (or subtracting an interval value from) a timestamp with time zone value, the days component advances (or decrements) the date of the timestamp with time zone by the indicated number of days 187 Chapter 9. Functions and Operators timezone_hour The hour component of the time zone offset timezone_minute The minute component of the time zone offset week The number of the week of the year polygon(path) polygon path to polygon polygon(path ’((0,0),(1,1),(2,0))’) It is possible to access the two component numbers of a point as though it were an array with indices 0 and 1. For example, if t.p is a point

interval value to (or subtracting an interval value from) a timestamp with time zone value, the days component advances (or decrements) the date of the timestamp with time zone by the indicated number of days negative values to zones west of UTC. timezone_hour The hour component of the time zone offset timezone_minute The minute component of the time zone offset week The number of the week of the year polygon(path) polygon path to polygon polygon(path ’((0,0),(1,1),(2,0))’) It is possible to access the two component numbers of a point as though it were an array with indices 0 and 1. For example, if t.p is a point

and date/time types. In addition, arrays, composite types, and ranges can be compared if their component data types are comparable. It is usually possible to compare values of related data types as well; specifiers are introduced by a % character and have the form %[position][flags][width]type where the component fields are: position (optional) A string of the form n$ where n is the index of the argument to interval value to (or subtracting an interval value from) a timestamp with time zone value, the days component advances or decrements the date of the timestamp with time zone by the indicated number of days

and date/time types. In addition, arrays, composite types, and ranges can be compared if their component data types are comparable. It is usually possible to compare values of related data types as well; specifiers are introduced by a % character and have the form %[position][flags][width]type where the component fields are: position (optional) A string of the form n$ where n is the index of the argument to interval value to (or subtracting an interval value from) a timestamp with time zone value, the days component advances or decrements the date of the timestamp with time zone by the indicated number of days

objects the related tables repre- sent. When the referencing table represents something that is a component of what is represented by the referenced table and cannot exist independently, then CASCADE could and date/time types. In addition, arrays, composite types, and ranges can be compared if their component data types are comparable. It is usually possible to compare values of related data types as well; specifiers are introduced by a % character and have the form %[position][flags][width]type where the component fields are: position (optional) A string of the form n$ where n is the index of the argument to

objects the related tables repre- sent. When the referencing table represents something that is a component of what is represented by the referenced table and cannot exist independently, then CASCADE could and date/time types. In addition, arrays, composite types, and ranges can be compared if their component data types are comparable. It is usually possible to compare values of related data types as well; specifiers are introduced by a % character and have the form %[position][flags][width]type where the component fields are: position (optional) A string of the form n$ where n is the index of the argument to

negative values to zones west of UTC. timezone_hour The hour component of the time zone offset timezone_minute The minute component of the time zone offset week The number of the week of the year polygon(path) polygon path to polygon polygon(path ’((0,0),(1,1),(2,0))’) It is possible to access the two component numbers of a point as though it were an array with indices 0 and 1. For example, if t.p is a point same way as UNION. The CASE and ARRAY constructs use the identical algorithm to match up their component expressions and select a result data type. UNION, CASE, and ARRAY Type Resolution 1. If all inputs