Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
logs_stats=# \d messages
Table "public.messages"
Column | Type | Modifiers
------------+--------------------------+-------------------------------------------------------
id | integer | not null default nextval('messages_id_seq'::regclass)
user | integer | not null
content | text |
action | action |
timestamp | timestamp with time zone | default now()
channel_id | integer |
Indexes:
"messages_pkey" PRIMARY KEY, btree (id)
logs_stats=# create index on messages (user);
ERROR: functions in index expression must be marked IMMUTABLE
Time: 0.348 ms
logs_stats=#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.