build_where_clause: Build Where Clause

In TuCai/podr: Common Functions for 'PHUSE' Open Data Repository

Description

This function builds a where clause for a SQL statement

Usage

build_where_clause(
  tab_name,
  col_name,
  col_value,
  con = getOption("podr_connection")
)

Arguments

tab_name	table name
col_name	column name
col_value	column value
con	The connection to PODR. Use connect_podr to establish a connection, or specify a variable containing the proper PostgreSQL connection into PODR yourself

Value

column definition in a data.frame

Author(s)

Hanming Tu

Examples

## Not run: 
cc <- conn_podr()
build_where_clause('css_2020_ae',con=cc)

## End(Not run)

TuCai/podr documentation built on June 8, 2021, 5:37 a.m.