På torsdag 06. januar 2022 kl. 14:13:40, skrev David G. Johnston < david.g.johns...@gmail.com <mailto:david.g.johns...@gmail.com>>: On Thursday, January 6, 2022, Andreas Joseph Krogh <andr...@visena.com <mailto:andr...@visena.com>> wrote:
I think you misread my message. What I want is for the subscript-version: ('{"key":"value"}'::jsonb)['key'] to return: ┌──────────┐ │ ?column? │ ├──────────┤ │ value │ └──────────┘ instead of ┌─────────┐ │ jsonb │ ├─────────┤ │ "value" │ └───────── A given syntax/operator can only return one thing so what you want is fundamentally not possible. That's not very helpful.... Apparently I'm after a solution which either casts this to varchar or a function that takes JSONB as argument and outputs the first field-value as varchar. -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com>