Re: SUBSTRING for a regular expression

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


SELECT
  SUBSTRING(description FROM '(.*), \\d{1,3},') AS vname,
  SUBSTRING(description FROM '.*, (\\d{1,3}),') AS age,
  SUBSTRING(description FROM '\\d{1,3}, of (.*?),? was charged')
    AS address,
  SUBSTRING(description FROM ' was charged ([^ ]+)') AS dow,
  SUBSTRING(description FROM ' was charged [^ ]+ with (.+)') AS charge
FROM police_log;

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200407062103
-----BEGIN PGP SIGNATURE-----

iD8DBQFA60wAvJuQZxSWSsgRAuKPAJ0QAeG0hdoJ/Ofqq/lXVtwMjyzQjACgoer3
kwPy0xvRiZxwr3cgPq6Rjwc=
=mF/C
-----END PGP SIGNATURE-----