On 06/12/2017 06:11 AM, Olav Gjerde wrote:
Oops sent previous post before actual reply.
I figured out the issue, it was as simple as some developers used the
default in Java's Hibernate which created the timestamp columns
without time zone.
Anyway I guess this is the correct approach that also
On 06/12/2017 06:11 AM, Olav Gjerde wrote:
I figured out the issue, it was as simple as some developers used the
default in Java's Hibernate which created the timestamp columns
without time zone.
Anyway I guess this is the correct approach that also take summer time
into consideration? And using
I figured out the issue, it was as simple as some developers used the
default in Java's Hibernate which created the timestamp columns
without time zone.
Anyway I guess this is the correct approach that also take summer time
into consideration? And using the immutable function wrapper is wrong?
On
I have a table that I try create an functional index on like this:
CREATE INDEX my_index_name
ON opening_hours (
opening_hours_type,
EXTRACT(YEAR FROM date),
EXTRACT(MONTH FROM date)
)
But I get the following error: functions in index expression must be
marked IMMUTABLE
But if I cha
