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.
  • While it still requires that you type the query correctly once, views are portable across relational databases (finally even MySQL as of 5.0)

    CREATE VIEW recipe_ingredient_list AS
      SELECT r.id, i.name
      FROM   ingredients i, recipe_ingredient ri, recipes r
      WHERE  r.id = ri.recipe_id
        AND  i.id = ri.ingredient_id

    so that you could use this query:

    SELECT name
    FROM   recipe_ingredient_list
    WHERE  id = ?

    And if you use PostgreSQL as the backend (so