Skip to content

Instantly share code, notes, and snippets.

@tomgullo

tomgullo/update_ltree.sql

Created April 3, 2013 12:46
Show Gist options
  • Save tomgullo/5300901 to your computer and use it in GitHub Desktop.
Save tomgullo/5300901 to your computer and use it in GitHub Desktop.
Download ZIP
update_ltree.sql
Raw
update_ltree.sql
update t_tree set path = text2ltree(replace( ltree2text(path), 'us.va', 'us.fl') );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment