pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Daniel Gustafsson <daniel@yesql.se>
To: Maarten van Gijssel <maarten@vgijssel.nl>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Non working example
Date: Mon, 1 Jul 2019 12:28:56 +0200
Message-ID: <25D2F3EB-FEA2-41FB-8B3B-2AC6249C0658@yesql.se> (raw)
In-Reply-To: <CAK45R1suL2BiRCcd_3tt-nPU8+pJ8B8Mv=5MybZO6WepbEccvQ@mail.gmail.com>
References: <156180512744.7504.7429434193941404768@wrigleys.postgresql.org>
	<F93DBDB6-61CE-4AF9-A0BA-799DAD93EABB@yesql.se>
	<CAK45R1suL2BiRCcd_3tt-nPU8+pJ8B8Mv=5MybZO6WepbEccvQ@mail.gmail.com>

> On 1 Jul 2019, at 12:19, Maarten van Gijssel <maarten@vgijssel.nl> wrote:
> 
> After I posted the question, I realised my mistake 😅. I was using the pg gem in Ruby to run the SQL "SELECT encode('123\000\001', 'base64')", the double quotes ensure the `\0` will be interpreted as a null byte hence throwing the error.

Aha, there we go.

> Sorry, my mistake!

No worries at all.

cheers ./daniel

view thread (4+ messages)

Message-ID: <25D2F3EB-FEA2-41FB-8B3B-2AC6249C0658@yesql.se>
Permalink:  ../25D2F3EB-FEA2-41FB-8B3B-2AC6249C0658@yesql.se/
Also on:    postgresql.org/message-id/25D2F3EB-FEA2-41FB-8B3B-2AC6249C0658@yesql.se

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: daniel@yesql.se, maarten@vgijssel.nl, pgsql-docs@lists.postgresql.org
  Subject: Re: Non working example
  In-Reply-To: <25D2F3EB-FEA2-41FB-8B3B-2AC6249C0658@yesql.se>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox