GetLoadedDictionary
Lists the currently loaded words for the specified user-dictionary.
If the user-dictionary is not loaded, then nothing is returned. You must use the OVER() clause with this function.
Syntax
SELECT GetLoadedDictionary(user-dictionary [using PARAMETERS language = string][, label='label']) OVER();
Parameters
Argument | Description |
---|---|
user-dictionary |
The user-dictionary list to retrieve. Valid values:
See Dictionaries and Mappings for details on each type. |
language |
The language of the dictionary:
|
label | The label of the dictionaries that you want to list. If you do not provide a label, Pulse uses the default dictionaries. |
Examples
Note: This example is from a three node cluster, so three copies of the words are returned.
SELECT GetLoadedDictionary('pos_words') OVER();
word ------------------------- :-) adequate admire admiringly adore adoringly adulation adventuresome advocated affable affably affordable affordably afordable all-around alluringly amazement ameliorate ample amusing --More-- SELECT GetLoadedDictionary('pos_words' using PARAMETERS language='english') OVER(); word ------------ simplicity (1 row) SELECT GetLoadedDictionary('pos_words' using PARAMETERS language='spanish') OVER(); word ------------- simplicidad (1 row)