Posts by Gustavo • 45 points
5 posts
-
0
votes2
answers1141
viewsA: Postgresql - Query data from a range and bring a boundary of lines but spaced
I decided as follows: SELECT TO_CHAR(t.date, 'YYYY-MM-DD HH24:00:00') AS data, AVG(t.h24::NUMERIC) AS value FROM telemetria t WHERE t.date >= (CURRENT_TIMESTAMP - INTERVAL '168 HOUR') GROUP BY…
-
0
votes2
answers1141
viewsQ: Postgresql - Query data from a range and bring a boundary of lines but spaced
Good morning Guys, all right? I have a performance problem in a system and need to solve by customizing an SQL. Let us imagine the following scenario: - A table with millions of records, each record…
-
1
votes4
answers3915
viewsA: Knowing if there are blanks
Try this: <?php //Tira os espaços em branco do começo e do fim $username = trim($_POST["username"]); if(empty($username) || is_null($username)) { echo 'O username não pode ser vazio'; } else if…
-
3
votes5
answers1137
viewsQ: Postgresql - Remove tuple referenced by another table
I’m having a problem that I didn’t find anything in Google (maybe I didn’t know to ask him) Just imagine the following: I have 11 tables, one call tbl_pai and 10 other calls tbl_filha1, tbl_filha2,…
-
0
votes1
answer140
viewsQ: Build for iOS and Android
I have a question about the build for iOS and Android. I recently lost the sources of an app I developed on these two platforms, but the apps are already in stores. I wondered in Apple support if it…