Re: [SQL] Help with optional parameters

rue, I think I was too focused on the "clean" output, your solution wastes less cycles and is more readable... Snipet updated, Thanks, -- MaXX ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [SQL] Help with optional parameters

OM my_table WHERE parama=1" "SELECT * FROM my_table WHERE parama=1 AND paramb=1" "SELECT * FROM my_table WHERE paramb=1" HTH, -- MaXX ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [SQL] generate_series to return row that doesn't exist in

e-expressions.html Perfect!! Time to RTFM again... Thanks, -- MaXX ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[SQL] generate_series to return row that doesn't exist in table...

n't get it... I prefer to generate missing rows "on the fly" intead of actually storing useless data on the table. Thanks for your help, -- MaXX ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [SQL] Merging lines with NULLs (with example data)

Thank you, and sorry for the late answer, I was far away from a decent internet connection... I'll try both your solutions, EXPLAIN ANALYSE will elect the winner... In any case that will be cleaner than my dirty hack (2 distinct queries) which generate a lot of garbage... Thanks again,

[SQL] Merging lines with NULLs (with example data)

p '2005-10-20','','2' '2005-10-20','3','' '2005-10-21','','1' '2005-10-21','5','' into that: gday,count_udp,count_tcp '2005-10-20','3','2' '20