On 2019-09-28T08:43:21 -0700 Rick Hillegas <[email protected]> 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
