Are periods supported in key names of JSONB values?

I'm storing the following shape of data in a JSONB type field:

column
--------------
{
  "foo.domain.com": {...},
  "bar.domain.com": {...}
}

column
--------------
{
  "foo.domain.com": {...},
  "bar.domain.com": {...}
}

However, when I run a query like:

client.from("table").select("column->foo.domain.com")

client.from("table").select("column->foo.domain.com")

client.from("table").select("column->'foo.domain.com'")

client.from("table").select("column->'foo.domain.com'")

I get the result

{foo: null}

{foo: null}

or an error

PGRST100, details: unexpected "'" expecting "-"

PGRST100, details: unexpected "'" expecting "-"

Supabase•4y ago•

7 replies

I'm storing the following shape of data in a JSONB type field:

column
--------------
{
  "foo.domain.com": {...},
  "bar.domain.com": {...}
}

column
--------------
{
  "foo.domain.com": {...},
  "bar.domain.com": {...}
}

However, when I run a query like:

client.from("table").select("column->foo.domain.com")

client.from("table").select("column->foo.domain.com")

client.from("table").select("column->'foo.domain.com'")

client.from("table").select("column->'foo.domain.com'")

I get the result

{foo: null}

{foo: null}

or an error

PGRST100, details: unexpected "'" expecting "-"

PGRST100, details: unexpected "'" expecting "-"