Skip to content

Instantly share code, notes, and snippets.

@twobraids
Created September 2, 2015 22:08
Show Gist options
  • Save twobraids/82496fcb2a52ccaaf1d2 to your computer and use it in GitHub Desktop.
Save twobraids/82496fcb2a52ccaaf1d2 to your computer and use it in GitHub Desktop.
this is even stranger. a return value of 0 from the position function apparently means "not found"
breakpad=> select uuid, position('\u0000' in raw_crash::text) from raw_crashes_20150824 where raw_crash::text like '%\u0000%';
uuid | position
--------------------------------------+----------
77c9e17c-39b8-409e-be5b-b63982150825 | 0
e3e9f28b-eff4-48fb-b4aa-bb8822150826 | 0
05a5a22e-21d7-4b85-aef0-3de3a2150828 | 0
b1b54310-402a-4bff-8cc2-f2c9b2150829 | 0
(4 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment