Posts by Joao Pedro • 36 points

• 1

  votes

  3

  answers

  2698

  views

  A: Using 2 versions of Java

  If you know how to edit system variables in windows. The most practical way is to have a variable called JAVA_HOME and in the variable PATH put %JAVA_HOME%/bin Then you only change the value of…

  java cmd

  answered 5 years, 5 months ago Joao Pedro 36

• 0

  votes

  1

  answer

  57

  views

  A: javahome installer argument (PSSAV)

  You will need to download JDK 6 from the Oracle website and set in your environment variables a variable called JDK_HOME with the path to the root of the folder you saved the JDK and add the…

  java linux jdk

  answered 5 years, 6 months ago Joao Pedro 36

• 0

  votes

  3

  answers

  102

  views

  A: Take Report with zero months

  You can also always use a CTE and a CASE (in postgres I always prefer to use CTE’s to improve reading and split kerys WITH consulta AS ( SELECT to_char(fi.data,'yyyy/mm') as Mes, count(fi.*) as…

  mysql sql postgresql query select

  answered 6 years, 1 month ago Joao Pedro 36

• 1

  votes

  1

  answer

  45

  views

  A: How to shrink a large query - Postgresql

  Dude, unfortunately not. Querys often have hundreds or even thousands of lines, it will depend on the size of the database. These are really big files. In Postgres you can better organize the querys…

  sql postgresql query

  answered 6 years, 1 month ago Joao Pedro 36

• 0

  votes

  0

  answers

  28

  views

  Q: Use more than one -> in the same PHP code line

  I made my transition from Java to PHP and recently bumped into something I used to do in Java but am not able to do in php. The following code creates an object of type "User" public function…

  php oop

  asked 6 years, 5 months ago Joao Pedro 36