Re: OT: Apache::Session::DBI vs postgresql? --help - Mailing list pgsql-general

>> To use this module, you will need these columns in a table
>> called 'sessions':
>>
>> id char(16)
>> length int(11)
>> a_session text
>>
>> which might be ducky for mysql, but on postgresql (7.0.3 anyhow)
>> "length" is illegal as a field name.

"length" is perfectly legal as a field name:

regression=# create table foo (f1 int, length int);
CREATE

The problem is that "int(11)", which is a MySQL-ism through and through;
there is no such construct in SQL92.  We'd take "int", or "bigint", or
"int8", or "numeric(11)", or "decimal(11)" ...

            regards, tom lane