Creste Index with nullable - Mailing list pgsql-admin

From Diego
Subject Creste Index with nullable
Date
Msg-id 43CCECE2.5030300@unimedijui.com.br
Whole thread Raw
Responses Re: Creste Index with nullable  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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




pgsql-admin by date:

Previous
From: "sandhya"
Date:
Subject: Fw: reg lo_import on windows
Next
From: Rodrigo Hjort
Date:
Subject: LOG: incomplete startup packet