# Get Cube of column in Postgresql

In order to get cube of column in postgresql we use POWER() function. POWER() function in posgresql gets the cube of the column. Let’s see how to

• Get cube value in postgresql
• Create the column which extracts the cube from another column

With an example for both

#### Get Cube in Postgresql:

POWER() function in posgresql gets the cube value

```SELECT POWER(3,3) AS "Cube";
```

So the cube will be #### Get Cube of column in Postgresql table:

We use table student_details ```SELECT *,POWER(gradscore,3) AS cube_gradscore FROM student_detail;
```

We have created a column and stored cube of gradscore column.

So the resultant table will be
{"ft_lang_label":"__label__en","ft_lang_prob":0.5736619,"math_prob":0.8415521,"size":617,"snap":"2022-27-2022-33","text_gpt3_token_len":145,"char_repetition_ratio":0.1680261,"word_repetition_ratio":0.06,"special_character_ratio":0.21880065,"punctuation_ratio":0.08547009,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.987155,"pos_list":[0,1,2,3,4,5,6],"im_url_duplicate_count":[null,1,null,1,null,1,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2022-07-02T17:03:24Z\",\"WARC-Record-ID\":\"<urn:uuid:f79259d2-97e0-4c11-aad2-14872b5101c4>\",\"Content-Length\":\"93900\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:0c7abd24-7d34-4e43-9f6f-e1140f131fb9>\",\"WARC-Concurrent-To\":\"<urn:uuid:e529390a-f3a2-4217-955c-e420b79b7617>\",\"WARC-IP-Address\":\"172.67.190.10\",\"WARC-Target-URI\":\"https://www.datasciencemadesimple.com/get-cube-of-column-in-postgresql/\",\"WARC-Payload-Digest\":\"sha1:QOMKV7YGYM4QYDWFQ3JL7MGH2LFK4OLK\",\"WARC-Block-Digest\":\"sha1:S2SPHWM4AEZORQWJKZRJU2DFRHUAN5JE\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2022/CC-MAIN-2022-27/CC-MAIN-2022-27_segments_1656104189587.61_warc_CC-MAIN-20220702162147-20220702192147-00051.warc.gz\"}"}