NovaStar Database Reference / Functions / pointfromremoteid
Overview
The pointfromremoteid function takes a string that is either a comma delimited list of point remote IDs or *. It then gets a list of point database IDs - the database IDs corresponding to the remote IDs, or if *, all the point database IDs.
The functions are defined in the point.sql file distributed with the NovaStar installer.
Function Usage
The function syntax is as follows.
pointfromremoteid(
IN remoteidlist text)
The function returns a comma delimited list in a string.
Function parameters are as follows.
Function Parameters
| Parameter | Description |
|---|---|
remoteidlist |
A point delimited list of point remote IDs or the string *. |
The following is an example of usage.
select * from pointfromremoteid('1,2,3');