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:
|
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)