File: functions.sql

package info (click to toggle)
postgis 1.3.3-3
  • links: PTS, VCS
  • area: main
  • in suites: lenny
  • size: 10,468 kB
  • ctags: 4,310
  • sloc: sql: 73,321; ansic: 35,513; xml: 6,160; java: 6,061; sh: 3,428; perl: 1,447; cpp: 987; makefile: 727; yacc: 276; python: 192
file content (21 lines) | stat: -rw-r--r-- 639 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

-- Create a function to call the java function
CREATE OR REPLACE FUNCTION public.helloworld()
  RETURNS "varchar" AS
    'org.postgis.pljava.HelloWorld.helloWorld'
  LANGUAGE 'java' VOLATILE;  

SELECT sqlj.drop_type_mapping('public.geometry');

SELECT sqlj.add_type_mapping('geometry', 'org.postgis.pljava.PLJGeometry');

CREATE OR REPLACE FUNCTION public.getSize(geometry)
  RETURNS "int4" AS
    'org.postgis.pljava.HelloWorld.getSize'
  LANGUAGE 'java' IMMUTABLE STRICT;  

CREATE OR REPLACE FUNCTION public.getString(geometry)
  RETURNS "text" AS
    'org.postgis.pljava.HelloWorld.getString'
  LANGUAGE 'java' IMMUTABLE STRICT;