Просмотр исходного текста страницы PostgreSQL/Data Type/Cast

==Cast char as integer==



   
  <!-- start source code -->
   
    <source lang="sql">

postgres=#
postgres=#
postgres=# SELECT 1 + CAST("1" || "2" AS integer) AS add_on_to_twelve;
 add_on_to_twelve
------------------
               13
(1 row)
postgres=#
           
       </source>
    
   


==round(==



   
  <!-- start source code -->
   
    <source lang="sql">

postgres=# SELECT round(4.0, 4);
 round
--------
 4.0000
(1 row)
postgres=#
           
       </source>
    
   


==round(CAST (4 AS numeric), 4)==



   
  <!-- start source code -->
   
    <source lang="sql">
postgres=# SELECT round(CAST (4 AS numeric), 4);
 round
--------
 4.0000
(1 row)
postgres=#
           
       </source>
    
   


==SELECT 1 + ("1" || "2")::integer==



   
  <!-- start source code -->
   
    <source lang="sql">
postgres=#
postgres=#
postgres=# SELECT 1 + ("1" || "2")::integer AS add_one_to_twelve;
 add_one_to_twelve
-------------------
                13
(1 row)
postgres=#
           
       </source>