NovaStar Database Reference / Functions / data_partition_oldest
Overview
data_partition_oldest gets the data_YYYY_MM name of the oldest data partition table in the NovaStar database.
It is defined in the data_partition.sql file distributed with the NovaStar installer.
Function Usage
The data_partition_oldest function syntax is as follows.
data_partition_oldest()
The function returns a string, data_YYYY_MM, that is the name of the oldest data partition table in the database.
The following is an example of usage.
select * from data_partition_oldest();