> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page
> Sent: 12 June 2006 12:13
> To: Andrus; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] bpchar_pattern_ops not shown
> in index command
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrus
> Sent: 06 June 2006 09:17
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] bpchar_pattern_ops not shown in
> index command
>
> To reproduce,
To reproduce, run:
create table foo ( bar char(20));
CREATE UNIQUE INDEX bar_pattern_idx ON foo(LOWER(bar) bpchar_pattern_ops);
Observed in pgadmin:
CREATE UNIQUE INDEX bar_pattern_idx
ON foo
USING btree
(lower(bar::text));
Expected:
bpchar_pattern_ops clause must also be present
Plat
