Creste Index with nullable

From: Diego <diego(at)unimedijui(dot)com(dot)br>
To: pgsql-admin(at)postgresql(dot)org
Subject: Creste Index with nullable
Date: 2006-01-17 13:10:58
Message-ID: 43CCECE2.5030300@unimedijui.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-01-17 15:20:50 Re: Creste Index with nullable
Previous Message Rodrigo Hjort 2006-01-17 12:33:56 LOG: incomplete startup packet