Posts by Rafael Calino • 111 points
7 posts
-
-2
votes1
answer106
viewsQ: Java array problem to read from database
I have a Java function where I weigh a phone number and it returns me which trunk the call will exit according to the regular expression that is saved in database in a column called…
-
1
votes1
answer65
viewsA: UPDATE field BIGINT[] from a SELECT
Solved . UPDATE callcenter.pausa SET permissao_ver = array(SELECT cod_grupo FROM crm.usuariosgrupos WHERE habilitar = 1) WHERE habilitado = 1 AND permissao_ver is null…
-
0
votes1
answer65
viewsQ: UPDATE field BIGINT[] from a SELECT
I have an update to a field permissao_ver Being the same guy bigint[], field response : '{1,2,3,4,5,11,44,56,75,11}' My Query UPDATE callcenter.pausa SET permissao_ver = '{"(SELECT cod_grupo FROM…
-
2
votes1
answer94
viewsQ: WHERE in bigint field[]
I have to perform a query to know if the code of a group is in the permissions to see the field. SELECT * FROM callcenter.pausa WHERE habilitado = 1 AND permissao_ver::varchar ilike '%1%' ORDER BY…
-
3
votes4
answers19788
viewsA: How do I update with a Join?
with t as ( -- Any generic query which returns rowid and corresponding calculated values select t1.id as rowid, f(t2, t2) as calculatedvalue from table1 as t1 join table2 as t2…
-
2
votes3
answers392
viewsQ: UPDATE SUM +1 to decimal
I need to assemble a UPDATE in a table however, in the value field: '1481126826.2363343', I need this number to turn '1481126826.2363344' To query that I’m trying and the next : UPDATE…
postgresqlasked Rafael Calino 111 -
3
votes2
answers572
viewsA: Difference between Compact function and literal array assignment
I don’t think you will find any performance gains using any of the available methods to the detriment of others. This really comes down to legibility and what makes the most sense when looking at…