Creating the Distance() function
About this task
To create the Distance() function:
Procedure
- Choose Edit > Insert > Routine and type the following
information in the New Routine wizard.
Routine Property Value Routine Name (SQL) Distance Language C Return type double precision Statement Local Variables No Arguments - Name: Pnt1, Type: Pnt, Default: leave blank
- Name: Pnt2, Type: Pnt, Default: leave blank
Options for how the database server calls this routine Only the Routine does not accept NULL arguments check box must be checked; clear the Routine may return inconsistent check box. Routine Name (C) Distance Shared object path Leave as default Behavior of Routines Well-behaved Special Stack Requirements None Cost of a Routine 0 Related Routines None Object grant privileges Grant execute privileges - Click Finish and then choose Project > Save to save your project.