Re: Constraint: string length must be 32 chars
| От | Alexander Farber |
|---|---|
| Тема | Re: Constraint: string length must be 32 chars |
| Дата | |
| Msg-id | AANLkTi=FgCn-N7taV2L8Fo3RK6Mgx_pG+UodOuoijoiv@mail.gmail.com обсуждение исходный текст |
| Ответ на | Constraint: string length must be 32 chars (Alexander Farber <alexander.farber@gmail.com>) |
| Ответы |
Re: Constraint: string length must be 32 chars
Re: Constraint: string length must be 32 chars |
| Список | pgsql-general |
snake=> create table gps (
id varchar(32) primary key CONSTRAINT id_length char_length(id)=32,
stamp timestamp DEFAULT current_timestamp,
pos point);
ERROR: syntax error at or near "char_length"
LINE 2: id varchar(32) primary key CONSTRAINT id_length char_length(...
^
snake=> create table gps (
id varchar(32) primary key CHECK id_length char_length(id)=32,
stamp timestamp DEFAULT current_timestamp,
pos point);
ERROR: syntax error at or near "id_length"
LINE 2: id varchar(32) primary key CHECK id_length char_length(id)=3...
^
snake=> create table gps (
id varchar(32) primary key CHECK char_length(id)=32,
stamp timestamp DEFAULT current_timestamp,
pos point);
ERROR: syntax error at or near "char_length"
LINE 2: id varchar(32) primary key CHECK char_length(id)=32,
^
Sorry, any ideas? (I know it's a stupid question)
Alex
В списке pgsql-general по дате отправления: