On Wed, 2006-11-29 at 21:12 +0100, Paul J Stevens wrote:
>
> Could someone please confirm this sql snippet on pg-7 please?
>
> create table testtable (id varchar(100) default '' not null);
> create index testtable_1 on testtable(lower(id));
Welcome to psql 7.4.6, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
kci=# create table testtable (id varchar(100) default '' not null);
CREATE TABLE
kci=# create index testtable_1 on testtable(lower(id));
CREATE INDEX
kci=#
--
Jesse Norell - [EMAIL PROTECTED]
Kentec Communications, Inc.
