<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.64 2006/10/13 21:43:17 tgl Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.65 2006/10/16 17:28:03 momjian Exp $ -->

<chapter id="ddl">

<title>Data Definition</title>

<programlisting>

CHECK ( x = 1 )

CHECK ( county IN ( 'Oxfordshire', 'Buckinghamshire', 'Warwickshire' ))

CHECK ( outletID>= 100 AND outletID< 200 )

CHECK ( outletID&gt;= 100 AND outletID&lt; 200 )

</programlisting>

Ensure that the constraints guarantee that there is no overlap

between the key values permitted in different partitions. A common

<!-- $PostgreSQL: pgsql/doc/src/sgml/plpython.sgml,v 1.33 2006/09/03 22:23:58 tgl Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/plpython.sgml,v 1.34 2006/10/16 17:28:03 momjian Exp $ -->

<chapter id="plpython">

<title>PL/Python - Python Procedural Language</title>

AS $$

if (a is None) or (b is None):

return None

if a> b:

if a&gt; b:

return a

return b

$$ LANGUAGE plpythonu;

<!--

$PostgreSQL: pgsql/doc/src/sgml/ref/create_opclass.sgml,v 1.17 2006/09/1600:30:17 momjian Exp $

$PostgreSQL: pgsql/doc/src/sgml/ref/create_opclass.sgml,v 1.18 2006/10/1617:28:03 momjian Exp $

PostgreSQL documentation

-->

DEFAULT FOR TYPE _int4 USING gist AS

OPERATOR 3 &&,

OPERATOR 6 = RECHECK,

OPERATOR 7 @>,

OPERATOR 8<@,

OPERATOR 7 @&gt;,

OPERATOR 8&lt;@,

OPERATOR 20 @@ (_int4, query_int),

FUNCTION 1 g_int_consistent (internal, _int4, int4),

FUNCTION 2 g_int_union (bytea, internal),

grep'[^]a-z0-9"/!-]>'*.sgml ref/*.sgml

grep'<[^]a-z0-9"/!-]'*.sgml ref/*.sgml

grep"$@"'[^]a-z0-9"/!-]>'*.sgml ref/*.sgml

grep"$@"'<[^]a-z0-9"/!-]'*.sgml ref/*.sgml