Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Activity for Laurenz Albe
| Type | On... | Excerpt | Status | Date |
|---|---|---|---|---|
| Edit | Post #295736 | Initial revision | — | 6 months ago |
| Answer | — |
A: Redshift int casting from varchar - how to force early evaluation order? To keep PostgreSQL from pulling up the subquery in the CTE, you can add the keyword `MATERIALIZED`: ```sql WITH validversions AS MATERIALIZED ( SELECT DISTINCT appversion FROM tablename WHERE appversion '^[0-9.]+$' ) ``` Alternatively, you can create a function to cast `... (more) |
— | 6 months ago |