Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 65::bit(8)::"char"
- 65::bit(8)::int::"char"
- SELECT
- v,
- v::bit(8)::"char" AS noint,
- v::bit(8)::int::"char" AS "viaInt"
- FROM (VALUES (65)) AS t(v);
- v | noint | viaInt
- ----+-------+--------
- 65 | 0 | A
- (1 row)
- SELECT 65::bit(8);
- bit
- ----------
- 01000001
- (1 row)
- SELECT '01000001'::"char", '0'::"char";
- char | char
- ------+------
- 0 | 0
- (1 row)
- SELECT 128::bit(8);
- bit
- ----------
- 10000000
- (1 row)
- SELECT 128::bit(8)::"char";
- char
- ------
- 1
- (1 row)
- SELECT 128::bit(8)::int::"char";
- ERROR: "char" out of range
Add Comment
Please, Sign In to add comment