PostgreSQL (2nd Edition)
| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]
object code library C APIs Object IDs. [See OID] objects PgConnection ODBC connecting to servers 2nd 3rd environment handles 2nd 3rd connection strings SQLDriverConnect() 2nd 3rd 4th 5th data sources setting up in Windows 2nd setting up on UNIX systems error checking 2nd exit() printErrors() 2nd 3rd SQLDriverConnect() 2nd 3rd SQLError() SQLSTATE 2nd error messages handles 2nd allocating SQLError() parameters interactive query processors 2nd displayErrors() 2nd 3rd MyTable class MyTable constructor 2nd Prepare/Execute model 2nd processing results 2nd 3rd 4th 5th 6th SQLError() 2nd metadata types prerequisites for processing queries 2nd 3rd printResultSet() 2nd SQLExecDirect() 2nd SQLGetData() 2nd 3rd revoking user privileges structure of client application data sources 2nd 3rd database driver driver manager versus JDBC 2nd 3rd X/ Open CLI ODBC (open database connectivity) ODBC administrator OEO 2nd OFFSET selecting specific rows OID to table mapping in global directory OIDs oids 2nd OIDs backups operators size of syntax for literal values tables 2nd 3rd 4th wrapping omitting properties from dsn on error continue() OPAQUE open database connectivity. [See ODBC] opening cursors operands operational parameters CHECKPOINT SEGMENTS CHECKPOINT TIMEOUT COMMIT DELAY COMMIT SIBLINGS FSYNC MAX FSM PAGES MAX FSM RELATIONS MAX LOCKS PER TRANSACTION SHARED BUFFERS SORT MEM VACUUM MEM WAL BUFFERS WAL FILES WAL SYNC METHOD operators ## * operators + operator + operators - operators / operators = operator ?# ?- ? operators @ operators 2nd Aggregate 2nd AND Append 2nd 3rd 4th binary operators 2nd bit-shift operators numeric data types bit-wise operators numeric data types bit-wise operators for integers numeric data types BYTEA CAST() 2nd closest -point operators geometric data types commutator comparison operators complex expressions date/time values arithmetic date/time operators 2nd date/time comparison operators distance operators geometric data types geometric data types Group 2nd Hash 2nd Hash Join ILIKE matching patterns with regular expressions Index Scan 2nd intersection operators geometric data types left-shift operators (<<) LIKE matching patterns with regular expressions Limit 2nd logical operators BOOLEAN Materialize 2nd Merge Join 2nd 3rd 4th 5th Nested Loop 2nd network address data types 2nd NOT numeric data types arithmetic operators for floats arithmetic operators for integers OIDs OR overlap operators geometric data types pg_operator proximity operators geometric data types Result 2nd right-shift operators ( searching for operator functions 2nd 3rd Seq Scan 2nd 3rd 4th 5th Setop 2nd 3rd 4th Sort 2nd 3rd 4th string operators 2nd 3rd Subplan Subquery Scan Tid Scan transformation operators geometric data types 2nd 3rd 4th type conversion operators geometric data types unary operators Unique 2nd optimizer parameters CPU INDEX TUPLE COST CPU OPERATOR COST CPU TUPLE COST EFFECTIVE CACHE SIZE ENABLE HASHJOIN ENABLE INDEXSCAN ENABLE MERGEJOIN ENABLE NESTLOOP ENABLE SEQSCAN ENABLE SORT ENABLE TIDSCAN GEQO GEQO EFFORT GEQO GENERATIONS GEQO POOL SIZE GEQO RANDOM SEED GEQO SELECTION BIAS GEQO THRESHOLD KSQO RANDOM PAGE COST options for pg ctl start Id IU OR truth table for three-valued OR operator OR operators numeric data types Oracle-style dictionary views ORDER BY selecting specific rows 2nd 3rd 4th ordering recalls table 2nd 3rd 4th with alphasort() organizing data 2nd 3rd 4th 5th 6th 7th outer blocks outer tables outer-joins 2nd 3rd 4th output functions in C 2nd 3rd 4th 5th 6th in PostgreSQL 2nd 3rd overlap operators geometric data types overloading functions ownership securing data files transferring Unix 2nd 3rd
|