anthonydb practical-sql issues

anthonydb / practical-sql

Code and Data for the First Edition of "Practical SQL" by Anthony DeBarros, published by No Starch Press (2018).

Other

650 stars 399 forks source link

issues

Newest

Newest Most commented Recently updated Oldest Least commented Least recently updated

Chapter 1: column "school" of relation "teachers" does not exist

#45 tiergan-rey closed 2 weeks ago
1
Chapter 8: Try It Yourself Question 2

#44 jmpemberton closed 1 month ago
3
Chapter 14: Analyzing Spatial Data no geom column

#43 Pelil-tepes closed 1 month ago
12
Ch. 4 Copy | Mac OS | Error 42P01

#42 KingdomAnimalia closed 1 year ago
4
CHAPTER 8

#41 piotrmichaljaniszewski closed 1 year ago
5
Chapter 4: ERROR: value too long for type character varying(3) CONTEXT: COPY us_counties_2010, line 2, column state_us_abbreviation: "STUSAB"

#40 abdusali1234 closed 2 years ago
3
Chapter 4: Missing data column and unable to import CSV

#39 lmchugh17 closed 2 years ago
0
Installation Instructions for PL/Python Extension

#38 anthonydb opened 2 years ago
0
Chapter 15: Python program keeps closing database connection

#37 robml opened 2 years ago
3
Chapter 13: Datestyle Question

#36 robml closed 2 years ago
2
Error in executing factorial part of listing 5-3

#35 aman-313 opened 2 years ago
1
Chapter 5 Median Aggregator Code Incompatible with PostgreSQL14

#34 robml closed 2 years ago
3
Windows File/Folder Permissions for COPY

#33 anthonydb opened 2 years ago
3
"Chapter 4: COPY us_counties_2010 Permission Denied Question"

#32 gobinaryn opened 2 years ago
2
File access denied on MacBook Air using COPY

#31 DanielaScoppa closed 2 years ago
5
Chapter 3 Listing 3.1

#30 petelg closed 3 years ago
6
CH 4 Try it Yourself #2

#29 emiliemercier opened 3 years ago
1
Chapter 13 tsvector

#28 MatMel16 opened 3 years ago
5
Chapter 13 regexp error

#27 MatMel16 closed 3 years ago
5
Chapter 4 csv usa_counties2010.csv

#26 ki4111 opened 4 years ago
3
Chapter 4: Performing the census import with COPY.

#25 rollieM closed 4 years ago
9
Code Listing 5-7 returns duplicate rows

#24 felixDK closed 4 years ago
4
Improve try it yourself example - find both medians with one query

#23 ghost closed 4 years ago
1
Pg. 50; Listing 4-6 returning with "42601" parameter error

#22 esleipness closed 4 years ago
4
Chapter 8: Using GROUP BY with count()

#21 stephanie-y closed 4 years ago
1
chapter 4 retrieve census .csv file

#20 brentdata closed 5 years ago
8
Reference URL of page 256 is not working

#19 bennybhlin opened 5 years ago
1
Chapter 9 (Inspecting and modifying data) sample code of list 9-1 has a minor glitch

#18 bennybhlin closed 5 years ago
5
Chapter 5 Try it yourself

#17 katemartin9 closed 5 years ago
2
Regex match to newline characters on windows10

#16 ChandlerLutz opened 5 years ago
2
Chapter 7 Listing 8-1 Import Error

#15 anthonysim closed 5 years ago
5
Chapter 4 Exporting

#14 anthonysim closed 5 years ago
9
missing "," in chapter 6

#13 marcosfromrio opened 5 years ago
7
Extra data after last expected column

#12 herrmaak closed 5 years ago
1
TimescaleDB

#11 bucweat closed 5 years ago
3
regexp_match( ) do not work on PostgreSQL 11 for these cases

#10 jhl8917 closed 5 years ago
4
Chapter 4: Try it Yourself #1

#9 ghost closed 5 years ago
1
Ch. 4 ERROR: missing data for column "state_us_abbreviation"

#8 chouci closed 5 years ago
3
CHAPTER 5 Try It Yourself no.3 Answer Review

#7 tomyfalgui closed 6 years ago
2
Chapter 6: SELECTing w/ JOIN by state_fips or county_fips gives inaccurate results

#6 CactusKurt closed 6 years ago
5
Chapter 4: COPY us_counties_2010...

#5 CactusKurt closed 5 years ago
22
regexp_matches queries returning no data

#4 jberkus opened 6 years ago
6
Median taxi trip calculation too complicated

#3 jberkus closed 7 years ago
2
Error in importing pls_fy2015_pupld14a

#2 jberkus closed 7 years ago
8
Inclusion of COPY statements in DDL files prevents readers from simply loading them.

#1 jberkus opened 7 years ago
3