Postgresql : syntax error at or near "(" when adding a column

Asked May 13 '20 at 13:43

Active May 13 '20 at 15:17

Viewed 1,745 times

I've been trying to add stored generated column with this command

ALTER TABLE mtn_order
ADD COLUMN textsearchable_index_col tsvector
GENERATED ALWAYS AS (to_tsvector('english', coalesce(descr, '') || ' ' || coalesce(descrrep, ''))) STORED;

But I get error:

ERROR:  syntax error at or near "("
LINE 3: GENERATED ALWAYS AS (to_tsvector('english', coalesce(descr, ...
                            ^

What am i doing wrong?

UPDATE: Had to upgrade to version 12

edited May 13 '20 at 15:17

asked May 13 '20 at 13:43

Viktor

1

What does `select version();` show you? – May 13 '20 at 13:44
PostgreSQL 10.12 (Ubuntu 10.12-2.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit (1 row) – Viktor May 13 '20 at 13:46
4

Generated columns were introduced in Postgres 12. You will have to upgrade if you need them. – May 13 '20 at 13:47
i'll try, thank you – Viktor May 13 '20 at 13:49
i this you should use `ALIAS` instead of `AS` – javaNoob May 13 '20 at 13:51

Postgresql : syntax error at or near "(" when adding a column

0 Answers0