Advertisement
Guest User

Untitled

a guest
Jun 22nd, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. plato=# select func.person_info_compellation(t), func.person_info_compellation(t) ILIKE '%ist%' from func.view_person_info_latest AS t;
  2. person_info_compellation | ?column?
  3. --------------------------+----------
  4. Mrs Tonny Anderson | f
  5. Mr first_0 last_0 | f
  6. Mr first_1 last_1 | f
  7. Mr first_2 last_2 | f
  8. (4 rows)
  9.  
  10. plato=# select func.person_info_compellation(t), func.person_info_compellation(t) ILIKE '%st%' from func.view_person_info_latest AS t;
  11. person_info_compellation | ?column?
  12. --------------------------+----------
  13. Mrs Tonny Anderson | f
  14. Mr first_0 last_0 | t
  15. Mr first_1 last_1 | t
  16. Mr first_2 last_2 | t
  17. (4 rows)
  18.  
  19. plato=# select func.person_info_compellation(t), func.person_info_compellation(t) ILIKE '%first%' from func.view_person_info_latest AS t;
  20. person_info_compellation | ?column?
  21. --------------------------+----------
  22. Mrs Tonny Anderson | f
  23. Mr first_0 last_0 | t
  24. Mr first_1 last_1 | t
  25. Mr first_2 last_2 | t
  26. (4 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement