dict_lookup_by_key.sql 280 B

1234567891011121314
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. $key_text = AsDict(
  4. ('911', 'emergency'),
  5. ('200', 'two hundred'),
  6. ('150', 'one and half hundred'),
  7. ('023', 'funny'),
  8. ('075', '3/4 of hundred')
  9. );
  10. SELECT
  11. value,
  12. $key_text[key] as key_text
  13. from plato.Input;