Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id UAA23552 for postgres-dist; Sun, 20 Mar 1994 20:04:19 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199403210404.UAA23552@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from eng.ie.cuhk.hk (eng.ie.cuhk.hk [137.189.98.200]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id UAA23542 for <postgres@postgres.berkeley.edu>; Sun, 20 Mar 1994 20:04:14 -0800
Received: by eng.ie.cuhk.hk (5.57/Ultrix3.0-C)
	id AA19803; Mon, 21 Mar 94 12:07:23 +0800
Received: from csun03.COMP.HKP.HK by csun02.COMP.HKP.HK (4.1/SMI-4.1)
	id AA06478; Mon, 21 Mar 94 12:03:05 HKT
Date: Mon, 21 Mar 94 12:03:04 HKT
From: cs400514@comp.hkp.hk (Lee Siu Hoi (BACS4 Class A))
Message-Id: <9403210403.AA06478@csun02.COMP.HKP.HK>
To: postgres@postgres.Berkeley.EDU
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Sun, 20 Mar 94 20:04:19 -0800
Resent-XMts: smtp

Hi all,

I want to index on a composite attribute.  And I've tried the following command:


__________________________________

create test (i = int4) \g

define function j (language = "postquel", returntype = int4)
	arg is (test)
	as "retrieve (x = $1.i)" \g

define index test_index on test using btree (j int4_ops) \g

WARN:Mar 21 11:57:06:DefineIndex: attribute "j" not found

__________________________________


It seems that composite attribute j is not allowed to define index.

Can I define index on compsite attribute or user define function?


Thanks in advance.


Hoi