I'm using Postgres 9.5. I have a
name column of type "character varying". I wonder how to select rows where the column begins with a number, followed by a space, followed by any other data.
So I would want rows where the column looks like:
12 DAVE 1 abcDEF 12345 LAST
But not when it looks like:
MYCOLUMN 1TEXT =END