Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • I don't like calling things ugly, but double underscores are ugly. IMO they're subject to the whims of fonts/editors, so it's hard to tell if there's a single or double underscore.

    My initial reaction was the same as Jason's -- why do you need the quotes at all?

    • See my response above. It's illegal syntax to have a dot in the field name unless you're actually joining on that other table.

    • If two underscores are considred ugly, is there any reason you can't just type:

      SELECT id,
             first_name,
             last_name,
             other_table_id,
             other_table_name
      FROM   some_view

      It's probably pretty obvious that the prefix actually is a table name prefix. At least that's my experience when naming constraints in our databases. They follow that naming convention.

      Ovid, if you can post it, what would real life ex