GetLoadedMapping

Lists the currently loaded words for the specified user-defined mapping.

If the mapping is not loaded with LoadMapping , then nothing is returned. This function must be used with the OVER() clause.

Syntax

SELECT GetLoadedMapping('normalization' [using PARAMETERS language = string][, label='label']) OVER();

Parameters

Argument Description

mapping

The mapping list to retrieve. Currently the only mapping supported is:

normalization

Note: By default, the normalization list is empty.

language

The language of the dictionary:

  • 'english' or 'en'
  • 'spanish' or 'es'
label The label to which you want to load the specified mapping. If you do not include a label, Pulse loads the default UDDs.

Examples

SELECT GetLoadedMapping('normalization') OVER(); 
 key |      value
-----+-----------------
 hp  | hewlett packard
(1 row)

SELECT GetLoadedMapping('normalization' using PARAMETERS language='english') OVER();
 key |      value      
-----+-----------------
 hp  | hewlett-packard
 hp  | hewlett packard
(2 rows)

SELECT GetLoadedMapping('normalization' using PARAMETERS language='spanish') OVER();
   key   |     value      
---------+----------------
 hidalgo | miguel hidalgo
(1 row)

See Also