View source: R/db_tmp_tables.R
db_with_tmp_read | R Documentation |
This function is not exported. It creates a tempory table containing the keys that should be read to join them against the time series storage. This is much faster for larger selections than simple where clauses.
db_with_tmp_read(con, ts_keys, regex = FALSE, code, schema = "timeseries")
con |
RPostgres connection object. |
ts_keys |
character vector of time series identifiers. |
regex |
logical if set to TRUE, the ts_keys parameter is interpreted as a regular expression pattern. |
code |
expression Code to be evaluated after populating the temporary table on the database of a time series that is valid from the specified date. |
schema |
character name of the database schema. Defaults to 'timeseries' |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.