Home

Fix for apidoc

September 2, 2010 - 3:15pm — Anonymous
  1.   /**
  2.    * Overrides SelectQuery::orderBy().
  3.    *
  4.    * PostgreSQL adheres strictly to the SQL-92 standard and requires that when
  5.    * using DISTINCT or GROUP BY conditions, fields and expressions that are
  6.    * ordered on also need to be selected. This is a best effort implementation
  7.    * to handle the cases that can be automated.
  8.    *
  9.    * <code>
  10.    * SELECT n.*,nr.body FROM node LEFT JOIN node_revisions nr ORDER BY timestamp
  11.    * </code>
  12.    *
  13.    * In this query, it is not possible (without relying on the schema) to know
  14.    * whether timestamp belongs to node_revisions and needs to be added or is
  15.    * already selected by <code>n.*</code>. These cases will need to be corrected
  16.    * in the original query.
  17.    *
  18.    * Since this has a small performance impact, both by the additional
  19.    * processing in this function and in the database that needs to return the
  20.    * additional fields, this is done as an override instead of implementing it
  21.    * directly in SelectQuery::orderBy().
  22.    */

Submit Fix

Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Select the syntax highlighting mode to use.