From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Larry Rosenman <ler(at)lerctr(dot)org> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: create index on a jsonb timestamp field? |
Date: | 2019-05-19 19:55:54 |
Message-ID: | 7511.1558295754@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Larry Rosenman <ler(at)lerctr(dot)org> writes:
> On 05/18/2019 8:17 pm, Tom Lane wrote:
>> BTW, I'd had the idea that the GENERATED option in PG v13 would allow
>> setting up this sort of case without bothering with a handwritten
>> trigger, but it seems not:
>>
>> regression=# create table foo(data jsonb, ts timestamptz GENERATED
>> ALWAYS AS ((data->>'ts')::timestamptz) stored);
>> psql: ERROR: generation expression is not immutable
>>
>> I wonder if that's really necessary to insist on?
> Good question. Is that something the project is going to look into?
Well, I was just asking the question, not opining on whether it
was right or wrong. GENERATED is a SQL-spec feature, and it might
be that the semantics the spec calls for wouldn't work without
the restriction. I've not looked...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Corey Huinker | 2019-05-20 05:56:01 | Re: Table as argument in postgres function |
Previous Message | Larry Rosenman | 2019-05-19 19:37:55 | Re: create index on a jsonb timestamp field? |