Question : I have the following index I’m trying to modify by declaring the poLineNumberInteger key as numeric/integer instead of […]
Tag: cast
PostgreSQL custom operator UUID to varchar
Question : I have a rather complicated Postgres database in which many UUID fields were incorrect stored as VARCHAR. I’d […]
Is it possible to change the default style used by CAST/CONVERT when converting DATETIME? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Is there Postgres workaround for MSSQL’s try_cast function as used in my CASE expression?
Question : I am in need of some assistance/advice please. I have a query in MSSQL as an openquery to […]
PostgreSQL CAST() giving unexpected results
Question : I can’t seem to figure out how this is rounding overflow digits. It is most definitely not any […]
Converting DATE and TIME integers to timestamp
Question : I am trying to get a timestamp by combining date and time columns in my PostgresQL database and […]
MS SQL -Date and Time Style conversion problem
Question : I need to convert Date and Time Style from USA format to German and than cast that into […]
PostgreSQL – CAST vs :: operator on LATERAL table function
Question : While I can SELECT elem[1], elem[2] FROM ( VALUES (‘1,2’::TEXT) ) AS q(arr), LATERAL CAST(String_To_Array(q.arr, ‘,’) AS INT[]) […]
How to create an index on an integer json property in postgres
Question : I can’t figure out for the life of me how to create an index on a property of […]
MySQL Cast to TINYINT [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]