Skip to content

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

Description

@amutu

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions