> > >

PostgreSQL MCQs

Which of the following statements will cast the integer value 1 to type text?

SELECT text(1) AS cast_integer;

SELECT CAST(1, text) as cast_integer;

SELECT 1::text AS cast_integer;

SELECT 1 TO text AS cast_integer;

SELECT CAST(1 AS text) AS cast_integer;

Answer

Correct Answer: SELECT 1::text AS cast_integer;

Explanation:

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

PostgreSQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it