3 ms·
I've just learned SQL by doing. You're not including extensions here like stored procs and such right? I have a lot of "where my_func(x, y, z) = 1" type where
by magicalhippo 6y ago
I've just learned SQL by doing. You're not including extensions here like stored procs and such right?
I have a lot of "where my_func(x, y, z) = 1" type where clauses, so seem that would do what you say, no?
- nendroid 6y agoThat's a hack. The where clause itself is not decomposable. But if you made every where clause a single function taking in multiple parameters than yes that function is composable but you're taking extra steps to do a non-traditional coding style. Not even sure if stored procedures are part of the sql standard.... these seem to me to be just specific syntax additions added on by specific databases. I mean it works so why not. I could code all my SQL this way.