[not graphile related] check char_length < N VS character varying (N)

[mathroc]

In the documentation I’ve noticed the length of first_name and last_name is validated with a check

I’ve usually have a column with a maximum length on the type, eg: character varying(100)

So I’m wondering, is there differences/benefits between those 2 methods ?

thank you (and sorry for being off topic)

[benjie]

Have a read of this:

https://stackoverflow.com/a/4849030/141284

[mathroc]

thank you that’s what I was looking for

[benjie]

You're welcome 😊