In PostgreSQL, a function that returns one row and one column from a SQL query against a database table is called a "scalar function". A scalar function takes one or more input parameters and returns a single scalar value.
@SoftwareNuggets #softwarenuggets