On 2019-09-28T08:43:21 -0700 Rick Hillegas <rick.hille...@gmail.com> wrote:
> On 9/28/19 2:11 AM, Mark Raynsford wrote: > > create table core.users ( > > user_id char (16) for bit data not null, > > user_password_hash_algo varchar (64) not null, > > user_password_hash varchar (64) not null, > > user_email varchar (128) not null, > > user_display_name varchar (128) not null, > > user_locked boolean not null, > > > > constraint user_id_key primary key (user_id), > > constraint user_id_nonzero check (user_id != > > cast('\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0' as char(16) for bit data)), > > constraint user_display_name_unique unique (user_display_name)) > > Hi Mark, > > The SQL Standard syntax for BINARY literals is a little odd. It is > > X'<sequence of hex digits>' Hello! Thanks very much, that's what I was looking for! -- Mark Raynsford | http://www.io7m.com
pgpmvcBVpfhpz.pgp
Description: OpenPGP digital signature