Hacker News new | ask | show | jobs
by gardenhedge 968 days ago
With some simple clarification I got this

UPDATE your_table SET teaser = substring(full_text from '(\S+\s*){1,200}')