Constraint: string length must be 32 chars

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Constraint: string length must be 32 chars
Дата
Msg-id AANLkTi=G+2XpqqtyXm-HNmU75eq5WKAWska0jE+eAuTs@mail.gmail.com
обсуждение исходный текст
Ответы Re: Constraint: string length must be 32 chars  (Raymond O'Donnell <rod@iol.ie>)
Re: Constraint: string length must be 32 chars  (Alexander Farber <alexander.farber@gmail.com>)
Re: Constraint: string length must be 32 chars  (Merlin Moncure <mmoncure@gmail.com>)
Re: Constraint: string length must be 32 chars  (Darren Duncan <darren@darrenduncan.net>)
Список pgsql-general
Hello,

I'm trying to create a table, where md5 strings will serve as primary keys.
So I'd like to add a constraing that the key length should be 32 chars long
(and contain [a-fA-F0-9] only):

create table gps (
id varchar(32) primary key CONSTRAINT char_length(id)==32,
stamp timestamp DEFAULT current_timestamp,
pos point);

But it fails:

ERROR:  syntax error at or near "("
LINE 2: id varchar(32) primary key CONSTRAINT char_length(id)==32,
                                                         ^
Does anybody please know what's wrong here?

Thank you
Alex

В списке pgsql-general по дате отправления:

Предыдущее
От: Terry Laurenzo
Дата:
Сообщение: Re: Request for comment: pgjson project
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Automated Database Backups