Diego <diego@xxxxxxxxxxxxxxxxx> writes: > I can create a index like > "CREATE INDEX idx_test ON etqmov USING btree (name, last_name)" > using a nullable field? Will work fine? Sure. Note however that "last_name IS NULL" is not an indexable operation, so you won't be able to use the index to search for rows containing nulls. This may or may not matter to you, but if it does you'll need to think of another way to locate those rows. (Some people solve this sort of problem with partial indexes.) regards, tom lane
