revert function for to_json ? - Mailing list pgsql-general

From Marc Mamin
Subject revert function for to_json ?
Date
Msg-id B6F6FD62F2624C4C9916AC0175D56D8842154FC4@jenmbs01.ad.intershop.net
Whole thread Raw
Responses Re: revert function for to_json ?  (Marc Mamin <M.Mamin@intershop.de>)
List pgsql-general
Hello,
 
I'm looking for $subject
 
example:
 
how to revert
  select to_json(E'a\n''b'::text)
 
I can achieve it with something like this:
  select json_extract_path_text(('{"a":'||to_json(E'a\n''b'::text)||'}')::json,'a')
 
does anybody knows a  less ugly solution ?
 
regards,
 
Marc Mamin
 

pgsql-general by date:

Previous
From: Scott Mead
Date:
Subject: Re: postgresql embedded mode
Next
From: "David G. Johnston"
Date:
Subject: Re: postgresql embedded mode