> SWITCH <expression> > CASE <key_value> TABLE <table> [IN <table_space>] > CASE <key_value> TABLE <table> [IN <table_space>] > CASE <key_value> TABLE <table> [IN <table_space>] > DEFAULT <table> [IN <table_space>]
some examples: CREATE TABLE ttt ( id integer, txt varchar ) SWITCH id % 3 CASE 0 TABLE <table> [IN <table_space>] CASE 1 TABLE <table> [IN <table_space>] CASE 2 TABLE <table> [IN <table_space>] DEFAULT <table> [IN <table_space>] or SWITCH lower(txt) CASE 'hello' TABLE <table> [IN <table_space>] CASE 'world' TABLE <table> [IN <table_space>] CASE 'foo' TABLE <table> [IN <table_space>] CASE 'bar' TABLE <table> [IN <table_space>] DEFAULT <table> [IN <table_space>] -- Neu: GMX FreeDSL Komplettanschluss mit DSL 6.000 Flatrate + Telefonanschluss für nur 17,95 Euro/mtl.!* http://dslspecial.gmx.de/freedsl-surfflat/?ac=OM.AD.PD003K11308T4569a -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
