PostgreSQL Administration - Creste Index with nullable

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Creste Index with nullable

Diego

2006-01-17, 7:23 am

Hi,

I have a question!

create table test (
code int not null,
name varchar(40) not null,
last_name varchar(40) {this field is nullable}
)

I can create a index like
"CREATE INDEX idx_test ON etqmov USING btree (name, last_name)"
using a nullable field? Will work fine?

Thanks...
Diego Ziquinatti
From Brazil

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links