Question : How can I index a to_char() of a column? I have tried: adam_db=> CREATE INDEX updates_hourly_idx ON updates […]
Tag: string-representation
Why isn’t to_char IMMUTABLE, and how can I work around it?
Question : How can I index a to_char() of a column? I have tried: adam_db=> CREATE INDEX updates_hourly_idx ON updates […]
Unquoting JSON strings; print JSON strings without quotes
Question : SELECT json_array_elements(‘[“one”, “two”]’::json) gives result | json_array_elements | | :—————— | | “one” | | “two” | I […]
PostgreSQL function’s input/output as JavaScript nested objects [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]