Posted By

elektrovenik on 04/15/11


Tagged

postrgesql volatile


Versions (?)

Wrong volatile


 / Published in: SQL
 

URL: http://blog.rootkid.ru/postgresql/hranimie_proceduri_s_nevernim_atributom_volatile.html

  1. SELECT provolatile, proname, prosrc
  2. FROM pg_proc
  3. WHERE proowner != 10
  4. AND (prosrc NOT ilike '%delete%' AND prosrc NOT ilike '%insert%' AND prosrc NOT ilike '%update%')
  5. AND provolatile = 'v'
  6. ORDER BY proname

Report this snippet  

You need to login to post a comment.