Jim Spath on Nostr: nprofile1q…a39ss Thanks. I was thinking out loud as it were. The error was not from ...

nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqfaamn3h0axkv0t8jr9t5aqw743pe0flufgrl98k2rjlcvnlp2twsaa39ss (nprofile…39ss) Thanks. I was thinking out loud as it were. The error was not from the last name column, only triggered when I pulled in records with blanks in date fields. Weak view definition.

Fixed with:
CAST(case when f_N not like '%/%' then null else f__N end AS date)
in the view create statement.

#PostgreSQL