Skip to content

NovaStar Database Reference / Functions / data_notflag

Overview

The data_notflag function checks that a given flag (a single letter) is not present in a list of flags (a string). This is called by several additional functions that check each type of flag defined in NovaStar.

It is defined in the data_flags.sql file distributed with the NovaStar installer.

Function Usage

The data_notflag function syntax is as follows.

data_notflag(
  IN flags text, 
  IN flag text)

The function returns a boolean - true if flag is not in flags.

Function parameters are as follows.

data_select(...) Function Parameters

Parameter         Description Default
flags String containing flags to check - typically the contents of the flags column of a data table.
flag A single character, the NovaStar flag to check for.

For the set of flags (or string) M1 and the single flag V, the following call would return true:

select * from data_notflag('M1','V');

Troubleshooting

See Also

  • data_isflag - Function that checks the opposite of this one.

Functions that call data_notflag internally: