PostgreSQL

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


sql function, see function, sql sqrt(), 113 Ssl, 226 stdin, 173, 175 stdout, 173,175 Stonebraker, Michael, 1, 236 stored procedures, 203 strpos(), 113


subquery, 91-98,101 any, all, exists, 98 constant, 91-92 correlated, 92-96, 98 in,96-98 multicolumn, 98 non-select, 101 not in, 96-98 nulls, 96-98 performance, 253 returning multiple values, 96 subselect, see subquery substr(), 113 substring(), 113 sum, 49-51, 77 system tables, 223, 231 listing, 183


tab, 171 table


alias, 57, 73-74 alter, 143, 247, 261-264 creation, 13-14, 302-320, 436 destruction, 19-22, 347-348 master/detail, 77 naming, 60-62


permissions, 143,148,224,365-367,424426


system, see system tables temporary, 141-143,175 Tcl/Tk, 184,188,199-200, 203,242,395-396 template1, 225, 256 temporary table, see table, temporary text, 108-109,195-196 time, 23, 108, 110 time zone, 46 time, current, 115 timeofday(), 113 timestamp, 23, 108, 110


current, 7, 29, 115, 150, 305 to_char(), 113


to_date(), 113 to_number(), 113 to_timestamp(), 113


transaction, 121-130,265-267, 271-272,360 cursor, 137 deadlock, 128 foreign key, 164, 166 isolation level, 125-128 multistatement, 122-124 rollback, 122-124, 259-260, 426-427 visibility, 124-125 translate(), 113


trigger, 151, 203, 210-216, 258, 320-322, 348-349


trim(), 113, 166, 205 true, see boolean trunc(), 113 trust, 226 types, 250


union, 87-91


outer join, 101 unique


constraint, see constraint, unique index, see index, unique University of California at Berkeley, xxiii, 1, 3, 4, 236 unlisten, 445-446 update, 19, 55,101,128, 446-447 and from, 101-102, 257 foreign key, 159,162,164 grant, 143 object id, 81 on view, 148 rule, 149,151 select for, 128 subquery, 101 trigger, 210


upgrade, see administration, upgrade upper(), 111,113, 203


user, 223-224, 226, 325-327, 332-333, 350351, 355-356 alter, 264-265 variable, 6,115,182,185


vacuum, 133-134, 230, 248, 257, 448-451 analyze, 134, 230, 248, 448, 449 vacuumdb, 230, 450-451 varchar(), 23,108-109,195-196, 250 variables, 115


version, see administration, server version view, 148, 327-329, 351-352 and rules, 149-151 listing, 183


where, 17


and null, 25-26


and/or, 30-33

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