antoniop
committed
on 08 Jan 20
Reintroduce :num_count variable in postgres query, as for oracle counterpart (for postgres, 15 was hardcoded)

Notes:
- :num_count comes fr… Show more
Reintroduce :num_count variable in postgres query, as for oracle counterpart (for postgres, 15 was hardcoded)

Notes:

- :num_count comes from a parameter, defaulting to 100, instead of 15

- postgres 9.5 introduced table sampling, similar to what oracle does (but with different syntax)

- this postgres query would be portable, except for random()... maybe the random value could come from tcl...

Show less