23/09/2021 01:40:54  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Vacación MÉTODO->SelectPersonalNoReintegroVacacion ERROR->Invalid query: ERROR:  operator does not exist: character = integer
LINE 33:       AND pagpersal=0
                            ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
Whole query: 
					 SELECT *,
					        (CASE WHEN fecreivac>'2021-09-30'::date THEN 3
							     WHEN fecreivac<='2021-09-30'::date THEN 4
							     ELSE 1
							  END ) AS status_efectivo								 
					   FROM sno_vacacpersonal 
					  INNER JOIN sno_personalnomina ON sno_personalnomina.codemp = sno_vacacpersonal.codemp
											       AND sno_personalnomina.codper = sno_vacacpersonal.codper
					  WHERE sno_vacacpersonal.codemp='0001' 
						AND sno_vacacpersonal.fecdisvac < '2021-09-16'
						AND sno_vacacpersonal.fecpagvac < '2021-09-16'
						AND sno_vacacpersonal.stavac=2
						AND persalvac!='000'
						AND peringvac!='000'
						AND sno_personalnomina.codnom='1003'					 
					  UNION
				      SELECT *,
					        (CASE WHEN fecreivac>'2021-09-30'::date THEN 3
							      WHEN fecreivac<='2021-09-30'::date THEN 4
							     ELSE 1
							  END ) AS status_efectivo								 
					   FROM sno_vacacpersonal 
					  INNER JOIN sno_personalnomina ON sno_personalnomina.codemp = sno_vacacpersonal.codemp
											       AND sno_personalnomina.codper = sno_vacacpersonal.codper
					  WHERE sno_vacacpersonal.codemp='0001' 
						AND sno_vacacpersonal.fecdisvac BETWEEN '2021-09-16' AND '2021-09-30'
						AND sno_vacacpersonal.fecpagvac BETWEEN '2021-09-16' AND '2021-09-30'
						AND sno_vacacpersonal.stavac=2
						AND persalvac!='000'
						AND peringvac!='000'
						AND profueper=0
						AND pagpersal=0
						AND sno_personalnomina.codnom='1003'		
					 
						
				 

23/09/2021 01:50:37  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Vacación MÉTODO->SelectPersonalNoReintegroVacacion ERROR->Invalid query: ERROR:  syntax error at end of input
LINE 38:      
              ^
Whole query: 
					 SELECT *,
					        (CASE WHEN fecreivac>'2021-09-30'::date THEN 3
							     WHEN fecreivac<='2021-09-30'::date THEN 4
							     ELSE 1
							  END ) AS status_efectivo								 
					   FROM sno_vacacpersonal 
					  INNER JOIN sno_personalnomina ON sno_personalnomina.codemp = sno_vacacpersonal.codemp
											       AND sno_personalnomina.codper = sno_vacacpersonal.codper
					  WHERE sno_vacacpersonal.codemp='0001' 
						AND sno_vacacpersonal.fecdisvac < '2021-09-16'
						AND sno_vacacpersonal.fecpagvac < '2021-09-16'
						AND sno_vacacpersonal.stavac=2
						AND persalvac!='000'
						AND peringvac!='000'
						AND sno_personalnomina.codnom='1003'					 
					  UNION
					  /*
				      SELECT *,
					        (CASE WHEN fecreivac>'2021-09-30'::date THEN 3
							      WHEN fecreivac<='2021-09-30'::date THEN 4
							     ELSE 1
							  END ) AS status_efectivo								 
					   FROM sno_vacacpersonal 
					  INNER JOIN sno_personalnomina ON sno_personalnomina.codemp = sno_vacacpersonal.codemp
											       AND sno_personalnomina.codper = sno_vacacpersonal.codper
					  WHERE sno_vacacpersonal.codemp='0001' 
						AND sno_vacacpersonal.fecdisvac BETWEEN '2021-09-16' AND '2021-09-30'
						AND sno_vacacpersonal.fecpagvac BETWEEN '2021-09-16' AND '2021-09-30'
						AND sno_vacacpersonal.stavac=2
						AND persalvac!='000'
						AND peringvac!='000'
						AND profueper='0'
						AND pagpersal='0'
						AND sno_personalnomina.codnom='1003'		
					 */