Question : I have a Postgresql column that is a varchar that is saving a string that looks like ‘2 […]
Tag: cast
postgresql function CAST json ARRAY to A TYPE
Question : I try to cast a JSON to a TYPE VOID_EVENT_CREATE, but I didn’t work because of the array. […]
PostgreSQL parses string literal as record before calling cast
Question : In my PostgreSQL 9.6 database, I have a composite type, let’s call that type widget. I have a […]
Getting “Conversion failed when converting the nvarchar value to data type int.”
Question : I have a SQL Server table pairing zipcodes and lat/long geometry, such as below ID ZIP5 geom 1 […]
How to cast (a) a date value recorded as a VARCHAR to (b) a specific DATE format for (c) use in an ORDER BY clause
Question : How would I cast a column value (a “non-MySQL” DATE string retained as a VARCHAR) to a “MySQL […]
Why does Casting this string as a decimal fail?
Question : Why does casting this result of REGEXP_SUBSTR() to a DECIMAL fail? SELECT REGEXP_SUBSTR(‘Cost (-$14.18)’, ‘(?<=Cost [(]-[$])[0-9.]+’) AS _extracted, […]
float to varchar with no trailing zeros
Question : I am having a heck of a time trying to convert a FLOAT(53) field to a VARCHAR where […]
Why does implicit conversion from sql_variant (basetype decimal) not work well with float
Question : Why is ResultFloat = 0 in the query below? Am I missing a point within the cast/convert, sql_variant […]
Why isn’t it possible to cast to a timestamp in an index in PostgreSQL?
Question : I am working with a JSON document which I receive from an external source. In this document, there […]
how to get back the modified INOUT parameter in postgres
Question : I have two functions with a similar signature, lets say: CREATE FUNCTION func1(INOUT new “My_Table”) AS $$ … […]