MARC details
000 -LEADER |
fixed length control field |
07864cam a2200961Ma 4500 |
001 - CONTROL NUMBER |
control field |
ocn854569125 |
003 - CONTROL NUMBER IDENTIFIER |
control field |
OCoLC |
005 - DATE AND TIME OF LATEST TRANSACTION |
control field |
20220711204042.0 |
006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS--GENERAL INFORMATION |
fixed length control field |
m o d |
007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION |
fixed length control field |
cr cn||||||||| |
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
fixed length control field |
130715s2013 enka o 001 0 eng d |
040 ## - CATALOGING SOURCE |
Original cataloging agency |
E7B |
Language of cataloging |
eng |
Description conventions |
pn |
Transcribing agency |
E7B |
Modifying agency |
OCLCQ |
-- |
OCLCO |
-- |
OCLCF |
-- |
COO |
-- |
EBLCP |
-- |
YDXCP |
-- |
IDEBK |
-- |
UMI |
-- |
DEBSZ |
-- |
N$T |
-- |
KNOVL |
-- |
OCLCQ |
-- |
AGLDB |
-- |
ICA |
-- |
MOR |
-- |
PIFAG |
-- |
ZCU |
-- |
MERUC |
-- |
OCLCQ |
-- |
JBG |
-- |
OCLCQ |
-- |
OCLCO |
-- |
U3W |
-- |
D6H |
-- |
STF |
-- |
WRM |
-- |
OCLCQ |
-- |
VTS |
-- |
NRAMU |
-- |
ICG |
-- |
NLE |
-- |
INT |
-- |
VT2 |
-- |
AU@ |
-- |
OCLCQ |
-- |
OCLCO |
-- |
UKMGB |
-- |
OCLCQ |
-- |
OCLCO |
-- |
A6Q |
-- |
DKC |
-- |
OCLCQ |
-- |
UKAHL |
-- |
NLW |
-- |
OCLCQ |
-- |
AJS |
-- |
OCLCO |
015 ## - NATIONAL BIBLIOGRAPHY NUMBER |
National bibliography number |
GBB747685. |
Source |
bnb |
016 7# - NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER |
Record control number |
018014763 |
Source |
Uk |
019 ## - |
-- |
852757349 |
-- |
857717648 |
-- |
860713075 |
-- |
961562098 |
-- |
962701088 |
-- |
974769790 |
-- |
974861972 |
-- |
981867021 |
-- |
989428728 |
-- |
1005640116 |
-- |
1018043075 |
-- |
1041919219 |
-- |
1048744515 |
-- |
1049100126 |
-- |
1053492086 |
-- |
1058147862 |
-- |
1065944621 |
-- |
1081203821 |
-- |
1083599168 |
-- |
1103275223 |
-- |
1120029063 |
-- |
1129359017 |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
International Standard Book Number |
9781849516990 |
Qualifying information |
(e-book) |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
International Standard Book Number |
1849516995 |
Qualifying information |
(e-book) |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
International Standard Book Number |
1849516987 |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
International Standard Book Number |
9781849516983 |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
International Standard Book Number |
9781680153606 |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
International Standard Book Number |
1680153609 |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
Cancelled/invalid ISBN |
9781849516983 |
029 1# - (OCLC) |
OCLC library identifier |
AU@ |
System control number |
000052007097 |
029 1# - (OCLC) |
OCLC library identifier |
AU@ |
System control number |
000053309268 |
029 1# - (OCLC) |
OCLC library identifier |
AU@ |
System control number |
000059711039 |
029 1# - (OCLC) |
OCLC library identifier |
CHBIS |
System control number |
010003216 |
029 1# - (OCLC) |
OCLC library identifier |
CHNEW |
System control number |
000611845 |
029 1# - (OCLC) |
OCLC library identifier |
CHNEW |
System control number |
001051839 |
029 1# - (OCLC) |
OCLC library identifier |
CHVBK |
System control number |
313168563 |
029 1# - (OCLC) |
OCLC library identifier |
CHVBK |
System control number |
567706591 |
029 1# - (OCLC) |
OCLC library identifier |
DEBBG |
System control number |
BV041432070 |
029 1# - (OCLC) |
OCLC library identifier |
DEBBG |
System control number |
BV044189302 |
029 1# - (OCLC) |
OCLC library identifier |
DEBSZ |
System control number |
397572654 |
029 1# - (OCLC) |
OCLC library identifier |
DEBSZ |
System control number |
398279608 |
029 1# - (OCLC) |
OCLC library identifier |
DEBSZ |
System control number |
493124780 |
029 1# - (OCLC) |
OCLC library identifier |
NZ1 |
System control number |
15589107 |
029 1# - (OCLC) |
OCLC library identifier |
UKMGB |
System control number |
018014763 |
035 ## - SYSTEM CONTROL NUMBER |
System control number |
(OCoLC)854569125 |
Canceled/invalid control number |
(OCoLC)852757349 |
-- |
(OCoLC)857717648 |
-- |
(OCoLC)860713075 |
-- |
(OCoLC)961562098 |
-- |
(OCoLC)962701088 |
-- |
(OCoLC)974769790 |
-- |
(OCoLC)974861972 |
-- |
(OCoLC)981867021 |
-- |
(OCoLC)989428728 |
-- |
(OCoLC)1005640116 |
-- |
(OCoLC)1018043075 |
-- |
(OCoLC)1041919219 |
-- |
(OCoLC)1048744515 |
-- |
(OCoLC)1049100126 |
-- |
(OCoLC)1053492086 |
-- |
(OCoLC)1058147862 |
-- |
(OCoLC)1065944621 |
-- |
(OCoLC)1081203821 |
-- |
(OCoLC)1083599168 |
-- |
(OCoLC)1103275223 |
-- |
(OCoLC)1120029063 |
-- |
(OCoLC)1129359017 |
037 ## - SOURCE OF ACQUISITION |
Stock number |
CL0500000277 |
Source of stock number/acquisition |
Safari Books Online |
050 #4 - LIBRARY OF CONGRESS CALL NUMBER |
Classification number |
QA76.9.D3 |
Item number |
K76 2013eb |
072 #7 - SUBJECT CATEGORY CODE |
Subject category code |
COM |
Subject category code subdivision |
021000 |
Source |
bisacsh |
082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER |
Classification number |
005.7585 |
049 ## - LOCAL HOLDINGS (OCLC) |
Holding library |
MAIN |
100 1# - MAIN ENTRY--PERSONAL NAME |
Personal name |
Krosing, Hannu. |
9 (RLIN) |
350486 |
245 10 - TITLE STATEMENT |
Title |
PostgreSQL server programming : |
Remainder of title |
extend PostgreSQL and integrate the database layer into your development framework / |
Statement of responsibility, etc |
Hannu Krosing, Jim Mlodgenski, Kirk Roybal. |
260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) |
Place of publication, distribution, etc |
Birmingham : |
Name of publisher, distributor, etc |
Packt Pub., |
Date of publication, distribution, etc |
2013. |
300 ## - PHYSICAL DESCRIPTION |
Extent |
1 online resource (vi, 245 pages) : |
Other physical details |
illustrations (some color) |
336 ## - |
-- |
text |
-- |
txt |
-- |
rdacontent |
337 ## - |
-- |
computer |
-- |
c |
-- |
rdamedia |
338 ## - |
-- |
online resource |
-- |
cr |
-- |
rdacarrier |
490 1# - SERIES STATEMENT |
Series statement |
Community experience distilled |
500 ## - GENERAL NOTE |
General note |
Includes index. |
505 0# - FORMATTED CONTENTS NOTE |
Formatted contents note |
Cover; Copyright; Credits; About the Authors; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:What Is a PostgreSQL Server?; Why program in the server?; Using PL/pgSQL for integrity checks; About this book's code examples; Switching to the expanded display; Moving beyond simple functions; Data comparisons using operators; Managing related data with triggers; Auditing changes; Data cleaning; Custom sort orders; Programming best practices; KISS -- keep it simple stupid; DRY -- don't repeat yourself; YAGNI -- you ain't gonna need it; SOA -- service-oriented architecture. |
505 8# - FORMATTED CONTENTS NOTE |
Formatted contents note |
Type extensibilityOn caching; Wrap up -- why program in the server?; Performance; Ease of maintenance; Simple ways to tighten security; Summary; Chapter 2:Server Programming Environment; Cost of acquisition; Availability of developers; Licensing; Predictability; Community; Procedural languages; Platform compatibility; Application design; Databases are considered harmful; Encapsulation; What does PostgreSQL offer?; Data locality; More basics; Transactions; General error reporting and error handling; User-defined functions (UDF); Other parameters; More control; Summary. |
505 8# - FORMATTED CONTENTS NOTE |
Formatted contents note |
Chapter 3:Your First PL/pgSQL FunctionWhy PL/pgSQL?; Structure of a PL/pgSQL function; Accessing function arguments; Conditional expressions; Loops with counters; Looping through query results; PERFORM versus SELECT; Returning a record; Acting on function results; Summary; Chapter 4:Returning Structured Data; Sets and arrays; Returning sets; Returning a set of integers; Using a set-returning function; Returning rows from a function; Functions based on views; OUT parameters and records; OUT parameters; Returning records; Using RETURNS TABLE; Returning with no predefined structure. |
505 8# - FORMATTED CONTENTS NOTE |
Formatted contents note |
Returning SETOF ANYVariadic argument lists; Summary of RETURN SETOF variants; Returning cursors; Iterating over cursors returned from another function; Wrap up of functions returning a cursor(s); Other ways to work with structured data; Complex data types for modern world -- XML and JSON; XML data type and returning data as XML from functions; Returning data in the JSON format; Summary; Chapter 5:PL/pgSQL Trigger Functions; Creating the trigger function; Creating the trigger; Simple ""Hey, I'm called"" trigger; The audit trigger; Disallowing DELETE; Disallowing TRUNCATE. |
505 8# - FORMATTED CONTENTS NOTE |
Formatted contents note |
Modifying the NEW recordTimestamping trigger; Immutable fields trigger; Controlling when a trigger is called; Conditional trigger; Trigger on specific field changes; Visibility; And most importantly -- use triggers cautiously!; Variables passed to the PL/pgSQL TRIGGER function; Summary; Chapter 6:Debugging PL/pgSQL; ''Manual'' debugging with RAISE NOTICE; Throwing exceptions; Logging to a file; Advantages of RAISE NOTICE; Disadvantages of RAISE NOTICE; Visual debugging; Getting the debugger installed; Installing pgAdmin3; Using the debugger; Advantages of the debugger. |
520 ## - SUMMARY, ETC. |
Summary, etc |
This practical guide leads you through numerous aspects of working with PostgreSQL. Step by step examples allow you to easily set up and extend PostgreSQL. ""PostgreSQL Server Programming"" is for moderate to advanced PostgreSQL database professionals. To get the best understanding of this book, you should have general experience in writing SQL, a basic idea of query tuning, and some coding experience in a language of your choice. |
506 1# - RESTRICTIONS ON ACCESS NOTE |
Terms governing access |
Legal Deposit; |
Physical access provisions |
Only available on premises controlled by the deposit library and to one user at any one time; |
Authorization |
The Legal Deposit Libraries (Non-Print Works) Regulations (UK). |
Institution to which field applies |
WlAbNL |
540 ## - TERMS GOVERNING USE AND REPRODUCTION NOTE |
Terms governing use and reproduction |
Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force. |
Institution to which field applies |
WlAbNL |
590 ## - LOCAL NOTE (RLIN) |
Local note |
eBooks on EBSCOhost |
Provenance (VM) [OBSOLETE] |
EBSCO eBook Subscription Academic Collection - Worldwide |
630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE |
Uniform title |
PostgreSQL. |
9 (RLIN) |
309926 |
630 07 - SUBJECT ADDED ENTRY--UNIFORM TITLE |
Uniform title |
PostgreSQL. |
Source of heading or term |
blmlsh |
9 (RLIN) |
309926 |
630 07 - SUBJECT ADDED ENTRY--UNIFORM TITLE |
Uniform title |
PostgreSQL. |
Source of heading or term |
fast |
-- |
(OCoLC)fst01394262 |
9 (RLIN) |
309926 |
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
Topical term or geographic name as entry element |
Database management. |
9 (RLIN) |
6422 |
650 #6 - SUBJECT ADDED ENTRY--TOPICAL TERM |
Topical term or geographic name as entry element |
Bases de données |
General subdivision |
Gestion. |
9 (RLIN) |
875401 |
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM |
Topical term or geographic name as entry element |
COMPUTERS |
General subdivision |
Databases |
-- |
General. |
Source of heading or term |
bisacsh |
9 (RLIN) |
950127 |
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM |
Topical term or geographic name as entry element |
Database management. |
Source of heading or term |
fast |
-- |
(OCoLC)fst00888037 |
9 (RLIN) |
6422 |
655 #0 - INDEX TERM--GENRE/FORM |
Genre/form data or focus term |
Electronic books. |
655 #4 - INDEX TERM--GENRE/FORM |
Genre/form data or focus term |
Electronic books. |
700 1# - ADDED ENTRY--PERSONAL NAME |
Personal name |
Mlodgenski, Jim. |
9 (RLIN) |
350487 |
700 1# - ADDED ENTRY--PERSONAL NAME |
Personal name |
Roybal, Kirk. |
9 (RLIN) |
350488 |
776 08 - ADDITIONAL PHYSICAL FORM ENTRY |
Display text |
Print version: |
Main entry heading |
Krosing, Hannu. |
Title |
PostgreSQL Server Programming. |
Place, publisher, and date of publication |
Birmingham : Packt Publishing, ©2013 |
International Standard Book Number |
9781849516983 |
830 #0 - SERIES ADDED ENTRY--UNIFORM TITLE |
Uniform title |
Community experience distilled. |
856 40 - ELECTRONIC LOCATION AND ACCESS |
Uniform Resource Identifier |
<a href="https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=604055">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=604055</a> |
938 ## - |
-- |
Askews and Holts Library Services |
-- |
ASKH |
-- |
AH26850736 |
938 ## - |
-- |
EBL - Ebook Library |
-- |
EBLB |
-- |
EBL1220931 |
938 ## - |
-- |
ebrary |
-- |
EBRY |
-- |
ebr10728417 |
938 ## - |
-- |
EBSCOhost |
-- |
EBSC |
-- |
604055 |
938 ## - |
-- |
ProQuest MyiLibrary Digital eBook Collection |
-- |
IDEB |
-- |
cis26003739 |
938 ## - |
-- |
YBP Library Services |
-- |
YANK |
-- |
10832965 |
994 ## - |
-- |
92 |
-- |
INOPJ |