PostgreSQL

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

| box


| divide box by point (scale)


/


| char


| char


| char


| divide


/


| circle


| point


| circle


| divide


/


| float4


| float4


| float4


| divide

test=> do ~


List of operators


Op | Left arg | Right arg | Result | Description —-+———-+————+———+—————-


~    | float8 | float8 | float8 | exponentiation (x~y)


(1 row) test=> dd ~


Object descriptions Name | Object | Description


~    | operator | exponentiation (x~y)


(1 row)


test=> SELECT 2 + 3 » 4; ?column?


(1 row)


Figure 4.23: Operator examples


Style


Optional Ordering


Output for February 1, 1983


ISO


1983-02-01


Postgres


us or NonEuropean


02-01-1983


Postgres


European


01-02-1983


SQL


us or NonEuropean


02/01/1983


SQL


European


01/02/1983


German


01.02.1983

Table 4.8: Datestyle output


test=> SHOW DATESTYLE;


NOTICE: DateStyle Is ISO with US (NonEuropean) conventions SHOW variable


test=> SET DATESTYLE TO ‘SQL, EUROPEAN’;


SET variable


test=> SHOW DATESTYLE;


NOTICE:    DateStyle is SQL with European conventions


SHOW variable


test=> RESET DATESTYLE;


RESET VARIABLE test=> SHOW DATESTYLE;


NOTICE:    DateStyle is ISO with US (NonEuropean) conventions


SHOW VARIABLE


Figure 4.24: Show and reset examples


’postgres,European’. The iso datestyle and german datestyle are not affected by any of the other options.

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