org.eigenbase.sql
Enum SqlWriter.SubqueryStyle

java.lang.Object
  java.lang.Enum<SqlWriter.SubqueryStyle>
      org.eigenbase.sql.SqlWriter.SubqueryStyle

All Implemented Interfaces:

Serializable, Comparable<SqlWriter.SubqueryStyle>

Enclosing interface:

SqlWriter

public static enum SqlWriter.SubqueryStyle
extends Enum<SqlWriter.SubqueryStyle>

Style of formatting subqueries.

Enum Constant Summary

Black
Damian's style of subquery nesting.

Hyde
Julian's style of subquery nesting.

Method Summary

static SqlWriter.SubqueryStyle	valueOf(String name) Returns the enum constant of this type with the specified name.
static SqlWriter.SubqueryStyle[]	values() Returns an array containing the constants of this enum type, in the order they're declared.

Methods inherited from class java.lang.Enum

clone, compareTo, equals, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

Hyde

public static final SqlWriter.SubqueryStyle Hyde

Julian's style of subquery nesting. Like this:

SELECT *
 FROM (
     SELECT *
     FROM t
 )
 WHERE condition

Black

public static final SqlWriter.SubqueryStyle Black

Damian's style of subquery nesting. Like this:

SELECT *
 FROM
 (   SELECT *
     FROM t
 )
 WHERE condition

Method Detail

values

public static final SqlWriter.SubqueryStyle[] values()

Returns an array containing the constants of this enum type, in the order they're declared. This method may be used to iterate over the constants as follows:

for(SqlWriter.SubqueryStyle c : SqlWriter.SubqueryStyle.values())
        System.out.println(c);

Returns:

an array containing the constants of this enum type, in the order they're declared

valueOf

public static SqlWriter.SubqueryStyle valueOf(String name)

Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

IllegalArgumentException - if this enum type has no constant with the specified name