Re: [SQL] Calling the CTE for multiple inputs

Thanks for the info, used a join in order to do that, now I have a "print rows with zcount 0" problem in my new question at http://postgresql.1045698.n5.nabble.com/How-to-make-this-CTE-also-print-rows-with-0-as-count-td5726792.html -- View this message in context: http://postgresql.1045698.n5.n

[SQL] How to make this CTE also print rows with 0 as count?

I have a CTE based query, to which I pass about 2600 4-tuple latitude/longitude values using joins - these latitude longitude 4-tuples have been ID tagged and held in a second table called coordinates. These top left and bottom right latitude / longitude values are passed into the CTE in order to d

[SQL] Calling the CTE for multiple inputs

I have a CTE that takes top left and bottom right latitude/longitude values along with a start and end date and it then calculates the amount of user requests that came from those coordinates per hourly intervals between the given start and end date. However, I want to execute this query for about