psql_carf_query: PostgreSQL full-text search

Description Usage Arguments Value Examples

View source: R/psql_carf_query.R

Description

PostgreSQL full-text search

Usage

1
2
3
psql_carf_query(con, tbl, query = "", assuntos = NULL,
  contribuintes = NULL, acordaos = NULL, processos = NULL,
  start = "2019-01-01", end = NULL)

Arguments

con

connection

tbl

table

query

words to be searched. Separate by "&" (AND), "|" (OR), or "<->" (FOLLOWED BY) to search for more than one word.

assuntos

Vetor de assuntos

contribuintes

vetor de contribuintes

acordaos

vetor de acórdãos

processos

vetor de processos

start

start date in the format "yyyy-mm-dd"

end

end date in the format "yyyy-mm-dd"

Value

A data.frame with the cjpg decisions according to

Examples

1
2
3
4
5
## Not run: 
dplyr::copy_to(con, "julgados", df)
df <- psql_carf_query(con, "julgados", "IRPF")

## End(Not run)

jjesusfilho/carf documentation built on Nov. 4, 2019, 2:44 p.m.