gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Gnumed-devel] Backend dem.urb needs cleaner constraint


From: Jim Busser
Subject: [Gnumed-devel] Backend dem.urb needs cleaner constraint
Date: Fri, 07 Oct 2011 20:59:50 -0700

Currently in dem.urb

Indexes:
    "urb_pkey" PRIMARY KEY, btree (id)
    "urb_id_state_key" UNIQUE, btree (id_state, postcode, name)
    "idx_dem_urb_id_state" btree (id_state)
    "idx_urb_names" btree (name)
    "idx_urb_zips" btree (postcode)


suggest

    "urb_id_state_key" UNIQUE, btree (id_state, postcode, name)

should better be

    "urb_id_state_key" UNIQUE, btree (id_state, UPPER(postcode), UPPER(name))

-- Jim




reply via email to

[Prev in Thread] Current Thread [Next in Thread]