| From: | Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com> |
|---|---|
| To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
| Cc: | T L <tinlyx(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: printing JsonbPair values of input JSONB on server side? |
| Date: | 2019-03-19 14:50:35 |
| Message-ID: | CACxu=vJfLY8qAb6YQEK4UNg6zxCoGftS0YY344fcEprZZcwSVQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Yeah I'm not sure why you're looping using pointer math, the iterators are
there to provide that service. Another function to check out 'jsonb_each',
other than the set returning function parts, it does what it looks like
your are trying to do.
-Michel
On Mon, Mar 18, 2019 at 4:12 PM Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
wrote:
> >>>>> "T" == T L <tinlyx(at)gmail(dot)com> writes:
>
> T> Below is my test. It prints a strange character instead of "a"; and
> T> says that the value isn't numeric.
>
> Yeah, there's plenty else wrong with your code.
>
> Did you look at how JsonbToCStringWorker does it? that looks like the
> best example I can find on a quick scan.
>
> --
> Andrew (irc:RhodiumToad)
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Radoslav Nedyalkov | 2019-03-19 16:35:20 | subscription broken after upgrade to pg11 |
| Previous Message | Alexandre Arruda | 2019-03-19 12:26:18 | Re: recovery_target_time and WAL fetch with streaming replication |