borrar_.py

select * from public.directory_telephone where to_tsvector(name) @@ to_tsquery('morosini & paloma') union
select * from public.directory_telephone where to_tsvector(name) @@ to_tsquery('morosini <-> paloma') union
select * from public.directory_telephone where to_tsvector(street) @@ to_tsquery('morosini & paloma') union
select * from public.directory_telephone where to_tsvector(street) @@ to_tsquery('morosini <-> paloma') union

select * from public.directory_telephone where to_tsvector(phone) @@ to_tsquery('morosini & paloma') union
select * from public.directory_telephone where to_tsvector(phone) @@ to_tsquery('morosini <-> paloma') union
select * from public.directory_telephone where to_tsvector(name) @@ to_tsquery('morosini | paloma') union
select * from public.directory_telephone where to_tsvector(street) @@ to_tsquery('morosini | paloma') union
select * from public.directory_telephone where to_tsvector(phone) @@ to_tsquery('morosini | paloma')



dt._prepare_str_sql('morosini paloma', 'name', '&')
dt._prepare_str_sql('morosini paloma', 'name', '<->')
dt._prepare_str_sql('morosini paloma', 'street', '&')
dt._prepare_str_sql('morosini paloma', 'street', '<->')

dt._prepare_str_sql('morosini paloma', 'phone', '&')
dt._prepare_str_sql('morosini paloma', 'phone', '<->')

dt._prepare_str_sql('morosini paloma', 'name', '|')
dt._prepare_str_sql('morosini paloma', 'street', '|')
dt._prepare_str_sql('morosini paloma', 'phone', '|')
# --------------------------------------------------------------------------------------------

select * from public.directory_telephone where to_tsvector(name) @@ to_tsquery('morosini & paloma') union
select * from public.directory_telephone where to_tsvector(name) @@ to_tsquery('morosini <-> paloma') union
select * from public.directory_telephone where to_tsvector(street) @@ to_tsquery('morosini & paloma') union
select * from public.directory_telephone where to_tsvector(street) @@ to_tsquery('morosini <-> paloma') union

select * from public.directory_telephone where to_tsvector(phone) @@ to_tsquery('morosini & paloma') union
select * from public.directory_telephone where to_tsvector(phone) @@ to_tsquery('morosini <-> paloma') union
select * from public.directory_telephone where to_tsvector(name) @@ to_tsquery('morosini | paloma') union
select * from public.directory_telephone where to_tsvector(street) @@ to_tsquery('morosini | paloma') union
select * from public.directory_telephone where to_tsvector(phone) @@ to_tsquery('morosini | paloma')


def sql_str(text, fig):
  pass