Re^4: s/Perl/SQL/ ?

To nit-pick, != is not standard SQL. <> is. And ANSI SQL has substring(string FROM idx FOR len), as opposed to substr(string, idx, len)

Anyway, good work on the rewrite. I tried it myself and ended up with a similar statement (albeit with a few extra tables).

Comment on Re^4: s/Perl/SQL/ ? Select or Download Code

Replies are listed 'Best First'.
Re^5: s/Perl/SQL/ ? by roboticus (Chancellor) on Sep 10, 2012 at 22:33 UTC
Anonymous Monk: Nice catches. I've never read the SQL standard, so I should've phrased it something more like "commonly used/implemented". The substr is just a bobble on my side. I'm always using substring in perl and substr in SQL, so you'd think I would be sensitized to checking that, at least. Sigh. Updated both nodes. ...roboticus When your only tool is a hammer, all problems look like your thumb.	[reply]

Replies are listed 'Best First'.

Re^5: s/Perl/SQL/ ?
by roboticus (Chancellor) on Sep 10, 2012 at 22:33 UTC

Anonymous Monk:

Nice catches. I've never read the SQL standard, so I should've phrased it something more like "commonly used/implemented". The substr is just a bobble on my side. I'm always using substring in perl and substr in SQL, so you'd think I would be sensitized to checking that, at least.

Sigh.

Updated both nodes.

...roboticus

When your only tool is a hammer, all problems look like your thumb.

[reply]