Re: a problem with index and user define type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Weiping He <laser(at)zhengmai(dot)com(dot)cn>
Cc: Wang Mike <itlist(at)msn(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: a problem with index and user define type
Date: 2003-06-25 14:10:57
Message-ID: 25728.1056550257@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Weiping He <laser(at)zhengmai(dot)com(dot)cn> writes:
> because the data type (UUID) is a struct,
> and the uuid_eq() function accept two pointer to the value of struct uuid,
> if make it IMMUTABLE, postgresql would think it should not try to run
> the function, but return the cached value instead when it get two same
> pointers input,

No, it will not. Your claim above is entirely wrong; the fact that the
datatype is pass-by-reference doesn't affect anything (unless you've
failed to declare the datatype that way, but if so I'd not think it
would work at all).

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-06-25 14:40:53 Re: [GENERAL] capturing and storing query statement with rules
Previous Message Tom Lane 2003-06-25 13:53:35 Re: allowed user/db variables