Specify types for hardcoded select?

Question

SQL

Postgresql database
I have sql generated dynamically
And in order not to put questions in where conditions, I just wanted to

cross join 	(
  select null as grainGroupCode, 
       null as grainGroupName, 
       null as typeProductCode, 
       null as typeProductName, 
       null as date1 
  ) filters

But the trouble is, all such fields are perceived as strings, and filters are not required to be performed.

and (f.grainGroupCode is not null or 
    ggtpt.grain_group_id = cast(f.grainGroupCode as integer))

For numbers I do so
And for dates I don’t even know
Is it possible to set types when creating such a plate.

Answer 1

No need to obfuscate requests and try to confuse the scheduler. He's smart, but he's dumb.