Re: Getting json-value as varchar

På torsdag 06. januar 2022 kl. 14:13:40, skrev David G. Johnston <
david.g.johnston@gmail.com <mailto:david.g.johnston@gmail.com>>: On Thursday, 
January 6, 2022, Andreas Joseph Krogh <andreas@visena.com 
<mailto:andreas@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 
andreas@visena.com <mailto:andreas@visena.com> 
www.visena.com <https://www.visena.com> 
 <https://www.visena.com>