Guest User

Untitled

a guest
Apr 19th, 2018
220
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. 65::bit(8)::"char"
  2.  
  3. 65::bit(8)::int::"char"
  4.  
  5. SELECT
  6. v,
  7. v::bit(8)::"char" AS "noint",
  8. v::bit(8)::int::"char" AS "viaint"
  9. FROM (VALUES (65)) AS t(v);
  10. v | noint | viaint
  11. ----+-------+--------
  12. 65 | 0 | A
  13. (1 row)
  14.  
  15. SELECT 65::bit(8);
  16. bit
  17. ----------
  18. 01000001
  19. (1 row)
  20.  
  21. SELECT '01000001'::"char";
  22. char
  23. ------
  24. 0
  25. (1 row)
  26.  
  27. SELECT 128::bit(8);
  28. bit
  29. ----------
  30. 10000000
  31. (1 row)
  32.  
  33. SELECT 128::bit(8)::"char";
  34. char
  35. ------
  36. 1
  37. (1 row)
Add Comment
Please, Sign In to add comment