anthonydb/practical-sql
Code and Data for the First Edition of "Practical SQL" by Anthony DeBarros, published by No Starch Press (2018).
PLpgSQLNOASSERTION
Pinned issues
Issues
- 3
Chapter 8: Try It Yourself Question 2
#44 opened by jmpemberton - 12
- 7
missing "," in chapter 6
#13 opened by marcosfromrio - 3
Windows File/Folder Permissions for COPY
#33 opened by anthonydb - 22
Chapter 4: COPY us_counties_2010...
#5 opened by CactusKurt - 4
Ch. 4 Copy | Mac OS | Error 42P01
#42 opened by KingdomAnimalia - 5
CHAPTER 8
#41 opened by piotrmichaljaniszewski - 3
Chapter 4 csv usa_counties2010.csv
#26 opened by ki4111 - 3
Chapter 4: ERROR: value too long for type character varying(3) CONTEXT: COPY us_counties_2010, line 2, column state_us_abbreviation: "STUSAB"
#40 opened by abdusali1234 - 0
- 9
Chapter 4 Exporting
#14 opened by anthonysim - 0
- 3
- 2
Chapter 13: Datestyle Question
#36 opened by robml - 1
Error in executing factorial part of listing 5-3
#35 opened by aman-313 - 3
- 2
- 5
File access denied on MacBook Air using COPY
#31 opened by DanielaScoppa - 9
Chapter 4: Performing the census import with COPY.
#25 opened by rollieM - 6
Chapter 3 Listing 3.1
#30 opened by petelg - 1
CH 4 Try it Yourself #2
#29 opened by emiliemercier - 5
Chapter 13 regexp error
#27 opened by MatMel16 - 5
Chapter 13 tsvector
#28 opened by MatMel16 - 4
Code Listing 5-7 returns duplicate rows
#24 opened by felixDK - 4
- 1
Chapter 8: Using GROUP BY with count()
#21 opened by stephanie-y - 8
chapter 4 retrieve census .csv file
#20 opened by brentdata - 1
Reference URL of page 256 is not working
#19 opened by bennybhlin - 5
Chapter 9 (Inspecting and modifying data) sample code of list 9-1 has a minor glitch
#18 opened by bennybhlin - 2
Chapter 5 Try it yourself
#17 opened by katemartin9 - 2
- 5
Chapter 7 Listing 8-1 Import Error
#15 opened by anthonysim - 1
Extra data after last expected column
#12 opened by herrmaak - 3
TimescaleDB
#11 opened by bucweat - 4
- 1
Chapter 4: Try it Yourself #1
#9 opened by ikoval - 3
- 2
- 5
Chapter 6: SELECTing w/ JOIN by state_fips or county_fips gives inaccurate results
#6 opened by CactusKurt - 6
regexp_matches queries returning no data
#4 opened by jberkus - 2
Median taxi trip calculation too complicated
#3 opened by jberkus - 8
Error in importing pls_fy2015_pupld14a
#2 opened by jberkus - 3
Inclusion of COPY statements in DDL files prevents readers from simply loading them.
#1 opened by jberkus