Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- plato=# select func.person_info_compellation(t), func.person_info_compellation(t) ILIKE '%ist%' from func.view_person_info_latest AS t;
- person_info_compellation | ?column?
- --------------------------+----------
- Mrs Tonny Anderson | f
- Mr first_0 last_0 | f
- Mr first_1 last_1 | f
- Mr first_2 last_2 | f
- (4 rows)
- plato=# select func.person_info_compellation(t), func.person_info_compellation(t) ILIKE '%st%' from func.view_person_info_latest AS t;
- person_info_compellation | ?column?
- --------------------------+----------
- Mrs Tonny Anderson | f
- Mr first_0 last_0 | t
- Mr first_1 last_1 | t
- Mr first_2 last_2 | t
- (4 rows)
- plato=# select func.person_info_compellation(t), func.person_info_compellation(t) ILIKE '%first%' from func.view_person_info_latest AS t;
- person_info_compellation | ?column?
- --------------------------+----------
- Mrs Tonny Anderson | f
- Mr first_0 last_0 | t
- Mr first_1 last_1 | t
- Mr first_2 last_2 | t
- (4 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement