Module | Jekyll::Typo |
In: |
lib/jekyll/migrators/typo.rb
|
SQL | = | <<-EOS SELECT c.id id, c.title title, c.permalink slug, c.body body, c.published_at date, c.state state, COALESCE(tf.name, 'html') filter FROM contents c LEFT OUTER JOIN text_filters tf ON c.text_filter_id = tf.id EOS | This SQL should work for both MySQL and PostgreSQL, but I haven‘t tested PostgreSQL yet (as of 2008-12-16). |