Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

SELECT
     folio_users.users__.id,
     jsonb_extract_path_text (users__ .jsonb, 'personal', 'lastName') AS requestor_last_name,
     jsonb_extract_path_text (users__ .jsonb, 'personal', 'firstName') AS requestor_first_name
FROM
     folio_users.users__


The following expression will also get "lastName" and "firstName":

SELECT
     folio_users.users__.id,
     users__ .jsonb #>> '{personal, lastName}' AS requestor_last_name,
     users__ .jsonb #>> '{personal, firstName}' AS requestor_first_name
FROM
     folio_users.users__

Extracting "Third level" Data Fields

...