Search found 2 matches
- Thu Oct 06, 2016 12:29 pm
- Forum: General
- Topic: How to create projection for proper using of UPPER function?
- Replies: 1
- Views: 6106
How to create projection for proper using of UPPER function?
Hi, we've faced the situation when the operation WHERE UPPER(columnName) IN ('PRED1', 'PRED2', 'PRED3') works very bad. If I remove UPPER then it performs good. I've tried to play with projections and could not get it working properly. How can I solve that issue (maybe the problem is not in projecti...
- Fri Sep 23, 2016 10:17 am
- Forum: General
- Topic: Different NOW() values in default constraint and a function
- Replies: 1
- Views: 5098
Different NOW() values in default constraint and a function
Could anyone explain what is going on... I have following table: CREATE TABLE public.test ( a int, UpdateDate timestamp NOT NULL DEFAULT ('now()')::timestamptz ); INSERT INTO public.test (a) values (1); SELECT *, NOW() FROM public.test; And the output is: a UpdateDate NOW 1 2016-09-23 05:14:14 2016-...