¡@
php Programming Glossary: attnameMerge a table and a change log into a view in PostgreSQL http://stackoverflow.com/questions/10109564/merge-a-table-and-a-change-log-into-a-view-in-postgresql the latest values SELECT DISTINCT ON 1 2 c.unique_id a.attname AS col first_value c.value OVER PARTITION BY c.unique_id a.attname.. AS col first_value c.value OVER PARTITION BY c.unique_id a.attname ORDER BY c.updated_at DESC AS value FROM pg_catalog.pg_attribute.. JOIN changes c ON c.table_name c.column_name 'instances' a.attname WHERE a.attrelid 'instances' regclass add schema to avoid confusion..
Remove on* JS event attributes from HTML tags http://stackoverflow.com/questions/9462104/remove-on-js-event-attributes-from-html-tags Cheat Sheet The code redefs ' DEFINE tagname a z ^ s attname ^ s ^ s # first char can be pretty much anything including attval.. ' ' ^ s # unquoted values can contain quotes and attrib attname s s attval crap ^ s # most crap inside tag is ignored..
|