Skip to content

NovaStar Database Reference / Functions / numidfrompoint


Overview

The numidfrompoint function returns the numid for a point given the database id for said point.

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

Function Usage

The function syntax is as follows.

numidfrompoint(
  IN point_id integer)

The function returns an integer.

Function parameters are as follows.

Function Parameters

Parameter         Description
point_id The database ID for the point.

The following is an example of usage.

select * from numidfrompoint(1);

Troubleshooting

See Also