PostgreSQL

Скачать в pdf «PostgreSQL»

List of functions |


—-+—————


| _bpchar int4 | _varchar int4 | float4 | float8



Arguments


Result |    Function


————+—————


_bpchar    |    _bpchar


_varchar    |    _varchar


float4    |    abs


float8    |    abs test=> df int


List of functions


Result | Function |    Arguments


int2


—-+————


| int2


——+——-


| float4


int2


| int2


| float8


int2


| int2


| int2


int2


| int2


| int4


test=>


df upper

List of functions Result | Function | Arguments


———+———-+————


text | upper | text (1 row)


test=> dd upper


Object descriptions Name | Object | Description


——-+———-+————


upper | function | uppercase (1 row)


test=> SELECT upper(‘jacket’); upper


jacket


(1 row)


test=> SELECT sqrt(2.0);    — square root


sqrt


1.4142135623731 (1 row)


Figure 4.22: Function examples


test=> do


List of operators


Op


| Left arg


| Right arg


| Result


| Description


| int2


|


| int4


|


| int4


|


| int4


| factorial


| int8 |


|


| int2


| int8 | int4


| factorial |

test=> do /


List of operators


Op | Left arg | Right arg | Result |    Description


—-+———-+————+———-+———————


/


| box


| point

Скачать в pdf «PostgreSQL»