Re: [GENERAL] How to search a string inside a json structure

2015-11-07 Thread David G. Johnston
On Saturday, November 7, 2015, Sami Pietilä wrote: > How can I rename the columns coming from jsonb_ functions? Or is there a > better way of unpacking the list and items? > select * from function(...) [as] func-name_alias (col1_alias, col2_alias, etc...) David J.

[GENERAL] Error when test on DBT2 Postgresql

2015-11-07 Thread Tim Chou
Hi All, When I test the DBT2 with a large number of connections, I always get the error: Error in read.table(file = file, header = header, sep = sep, quote = quote, : no lines available in input Calls: read.csv -> read.table I have tracked the file and see the reason is there are no "TERMINAT