Miscellaneous non-aggregate functions

Miscellaneous non-aggregate functions are provided.

The following table describes the non-aggregate functions.

Table 1. Miscellaneous functions
Function	Description
`isfalse(c)`	True when condition `c` is not true or is unknown.
`isnotfalse(c)`	True when condition `c` is true or is unknown.
`istrue(c)`	True when condition `c` is not false or is unknown.
`isnottrue(c)`	True when condition `c` is false or is unknown.
`version()`	Returns the Netezza Performance Server SQL database version string.
`get_viewdef('v'’)`	Displays the SQL code that created the specified view.
`width_bucket`	Divides a range into equally wide intervals that are specified by num-buckets.