Returning JSON or JSONB - Mailing list pgsql-general

From Dane Foster
Subject Returning JSON or JSONB
Date
Msg-id CA+WxinJCCwJ6b1C=6xYkGtaDfUnRk6wmn9TTYsJV6zYN++xLZw@mail.gmail.com
Whole thread Raw
Responses Re: Returning JSON or JSONB  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-general
Hello,

I was wondering when returning JSON data from a PostgreSQL function for consumption by clients (e.g., PHP or Lua) does it make any difference to declare the function's return type as JSON or JSONB?

Now that I've actually written the question down it occurs to me that what I really want to know is which data type (JSON or JSONB or maybe TEXT) has the lowest overhead in terms of transformation and transmission at the PostgreSQL protocol level.

Thanks,

Dane

pgsql-general by date:

Previous
From: Scott Mead
Date:
Subject: Re: [BUGS] postgresql table data control
Next
From: Andreas Kretschmer
Date:
Subject: Re: Returning JSON or JSONB