Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

feature request:numeric and timestamp cs cast to bpchar cs #17

Closed
amutu opened this issue Mar 10, 2014 · 1 comment
Closed

feature request:numeric and timestamp cs cast to bpchar cs #17

amutu opened this issue Mar 10, 2014 · 1 comment

Comments

@amutu
Copy link

amutu commented Mar 10, 2014

now it is not support:
postgres=# select cs_hash_count( cs_cast(ts,'bpchar') || stacktopsignature) from samp3_get();
ERROR: cast to timeseries of CHAR(N) is not supported
CONTEXT: PL/pgSQL function cs_cast(timeseries,cs_elem_type) line 3 at RETURN
Time: 0.485 ms
postgres=# select cs_hash_count( cs_cast(ts,'varchar') || stacktopsignature) from samp3_get();
ERROR: cast to timeseries of CHAR(N) is not supported
CONTEXT: PL/pgSQL function cs_cast(timeseries,cs_elem_type) line 3 at RETURN
Time: 0.338 ms

so,result like this is not fuser riendly:
postgres=# select s.cnt,s.grp from samp3_get(),cs_project(cs_hash_count( ts || stacktopsignature)) as s(cnt bigint,grp char(128)) order by 1 desc limit 10;
NOTICE: IMCS command: cat
NOTICE: IMCS command: hash_count
NOTICE: IMCS command: project
cnt | grp
-----+----------------
336 | \x1F)z\x0C\x01
129 |
112 |
112 | @\x0B\x17\x01
109 |
109 | &ʤ\x12\x01
108 | @\x0B\x17\x01
107 | \x16>\x11\x01
106 |
104 | &ʤ\x12\x01
(10 rows)

Time: 5777.381 ms

@amutu
Copy link
Author

amutu commented Mar 10, 2014

duplicate with #17

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant