pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Function: st_transscale

 

 

Schema

public

 

Owner

postgres

 

Descriptions

args: geomA, deltaX, deltaY, XFactor, YFactor - Translates the geometry using the deltaX and deltaY args, then scales it using the XFactor, YFactor args, working in 2D only.

 

Options

Option

Value

Returns

public.geometry

Language

sql

Parameters

public.geometry

double precision

double precision

double precision

double precision

 

Definition

CREATE OR REPLACE FUNCTION public.st_transscale (
 public.geometry,
 double precision,
 double precision,
 double precision,
 double precision
)
RETURNS public.geometry AS
$span$
SELECT
ST_Affine($1,  $4, 0, 0,  0, $5, 0,
0, 0, 1,  $2 * $4, $3 * $5, 0)
$span$
LANGUAGE
'sql'
IMMUTABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST
100;

COMMENT ON FUNCTION public.st_transscale(public.geometry, double precision, double precision, double precision, double precision)
IS 'args: geomA, deltaX, deltaY, XFactor, YFactor - Translates the geometry using the deltaX and deltaY args, then scales it using the XFactor, YFactor args, working in 2D only.';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23
Previous topic Chapter index Next topic