Re: [SQL] unique index on function and column

2002-06-25 Thread Bruno Wolff III
On Tue, Jun 25, 2002 at 14:35:16 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > Bruno Wolff III <[EMAIL PROTECTED]> writes: > > Is there a simple way to do something like the following: > > create unique index inst_u_app on inst (lower(host), psport); > > > It looks like you can have an index on

Re: [SQL] unique index on function and column

2002-06-25 Thread Tom Lane
Bruno Wolff III <[EMAIL PROTECTED]> writes: > Is there a simple way to do something like the following: > create unique index inst_u_app on inst (lower(host), psport); > It looks like you can have an index on several columns, but not > several functions. The standard answer is to make a custom f

[SQL] unique index on function and column

2002-06-25 Thread Bruno Wolff III
Is there a simple way to do something like the following: create unique index inst_u_app on inst (lower(host), psport); It looks like you can have an index on several columns, but not several functions. ---(end of broadcast)--- TIP 2: you can get