Anthony DeBarros

Would also be interested in how you may handle this, @CSSEGISandData.

Hi, @CSSEGISandData, re-upping this thread. It would be helpful to let us know your plans regarding DC and whether you're looking at pulling its numbers from CDC. Thanks!

Hi, @ChandlerLutz! Thanks for sharing this and glad you got it working. Did you experience a similar issue with any of the other regexes, or just the one for the...

Thanks for noting this, @aman-313! Beginning with PostgreSQL 14, released in September 2021, the factorial operator (!) has been deprecated. Instead, we must use the `factorial()` function. I have made...

Sounds good -- thanks.

@jberkus Please note that during the chapter revisions I switched to the new PostgeSQL 10 function regexp_match() in these examples. The code in question is at: https://github.com/anthonydb/practical-sql/blob/master/Chapter_13/Chapter_13.sql#L88

@jberkus Whew ... glad it was something simple and not a mysterious hidden character issue. I do realize that relying on a PostgreSQL 10 function may pose an issue for...

Ah, that's too bad. Looks like they did indeed move it behind a paywall. You could substitute the PostGIS docs page on K Nearest Neighbor function: https://postgis.net/docs/geometry_distance_knn.html

Hello, @MatMel16 ... thank you for writing and for using my book. I am fairly certain the issue is that your computer is set to a default text search configuration...

Hmm, that's interesting. Would you please try something else? In your current pgAdmin session, run the following command: `SET default_text_search_config TO 'english';` That will set your text search language default...