Skip to content

NovaStar Database Reference / Functions / data_partition_newest


Overview

data_partition_newest gets the data_YYYY_MM name of the newest 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_newest function syntax is as follows.

data_partition_newest()

The function returns a string, data_YYYY_MM, that is the name of the newest data partition table in the database.

The following is an example of usage.

select * from data_partition_newest();

Troubleshooting

See Also