Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^4: s/Perl/SQL/ ?

by Anonymous Monk
on Sep 10, 2012 at 19:43 UTC ( #992839=note: print w/replies, xml ) Need Help??


in reply to Re^3: s/Perl/SQL/ ?
in thread 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).

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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://992839]
help
Chatterbox?
[Lady_Aleena]: Corion, I knew that, I was just giving Discipulus a hard time.
choroba likes the story at the end of the node
[choroba]: reminds me of the days at the bank
[Corion]: Lady_Aleena: Hehe ;-D
[Lady_Aleena]: Corion, it was PerlMonks who kept pushing me to get Linux, so now I know some of the commands to use in word play.
[Corion]: Lady_Aleena: :-D

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (9)
As of 2017-04-26 08:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (471 votes). Check out past polls.