Jim Spath on Nostr: ERROR: invalid input syntax for type date: " " #Fail And I have no clue why. Tricky ...
ERROR: invalid input syntax for type date: " "
#Fail
And I have no clue why. Tricky SQL to find records where a person has multiple date values in different rows.
This works:
last in ('Baker', 'Whiskey'', 'Spath')
This fails:
substr(last,1,1) in ('B', 'S', 'W)
Some kind of grouper-fisher-failer.
#Fail
And I have no clue why. Tricky SQL to find records where a person has multiple date values in different rows.
This works:
last in ('Baker', 'Whiskey'', 'Spath')
This fails:
substr(last,1,1) in ('B', 'S', 'W)
Some kind of grouper-fisher-failer.