pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Raschkowski, Michael <michael.raschkowski@auconet-it.com>
To: pgsql-bugs@lists.postgresql.org
Subject: Cannot create index on Jsonb timestamp field
Date: Mon, 13 Jan 2020 15:41:33 +0100
Message-ID: <002401d5ca1f$8d4d2da0$a7e788e0$@auconet-it.com> (raw)

Hi,

 

I am checking the possibilities of using jsonb fields and can’t create index
on jsonb element if I cast it to timestamp with time zone:

 

drop table if exists test_json;

create table test_json (j jsonb);

insert into test_json select jsonb_build_object('id',1,'time',
now()::timestamptz);

--OK

create index test_json_idx1 on test_json(((j->>'id')::integer));

--ERROR

create index test_json_idx2 on test_json(((j->>'time')::timestamptz));

 

The message is :

 

ERROR: FEHLER: Funktionen im Indexausdruck müssen als IMMUTABLE markiert
sein 

 

SQL state: 42P17

 


Viele Grüße / Kind regards,

Dr. Michael Raschkowski 
Software Architect

Auconet GmbH - ein Unternehmen der Beta Systems Gruppe
An den Treptowers 1, 12435 Berlin
Phone: +49 30 254 690-0
Fax: +49 30 254 690-199
Email:  <mailto:michael.raschkowski@auconet-it.com>
michael.raschkowski@auconet-it.com
 <http://www.auconet-it.com/; www.auconet-it.com


 

 

Mandatory Information for business emails according to German trade laws /
Pflichtangaben für geschäftliche E-mails gemäß Handelsgesetzbuch:

Auconet GmbH - ein Unternehmen der Beta Systems Gruppe
An den Treptowers 1
12435 Berlin
Germany
Phone: +49-(0)30-254 690-0
Fax: +49-(0))30-254 690-199
 <mailto:info@auconet-it.com> info@auconet-it.com
 <http://www.auconet-it.com/; www.auconet-it.com

Management / Geschäftsführer: Hartmut Bolten, Sebastian Zang
Legal form / Rechtsform: GmbH | Registered office / Sitz: Berlin
Commercial register / Handelsregister: Amtsgericht Charlottenburg HRB 141
887 B
VAT-ID / Ust-ID-Nr.: DE316422231 | Tax No. / St.-Nr.: 30/036/75431
Bank / Bankverbindung: Commerzbank AG, BIC: COBADEFF, IBAN: DE25 1004 0000
0230 9391 00

 

 

view thread (3+ messages)  latest in thread

Message-ID: <002401d5ca1f$8d4d2da0$a7e788e0$@auconet-it.com>
Permalink:  ../002401d5ca1f$8d4d2da0$a7e788e0$@auconet-it.com/
Also on:    postgresql.org/message-id/002401d5ca1f$8d4d2da0$a7e788e0$@auconet-it.com

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-bugs@postgresql.org
  Cc: michael.raschkowski@auconet-it.com
  Subject: Re: Cannot create index on Jsonb timestamp field
  In-Reply-To: <002401d5ca1f$8d4d2da0$a7e788e0$@auconet-it.com>
  References: <002401d5ca1f$8d4d2da0$a7e788e0$@auconet-it.com>

* 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