- Newest
- Most votes
- Most comments
Hi pby,
I suspect the difference in the behavior may be tied to the base PostgreSQL version for each the test cases you demonstrate.
Redshift is a single version derivative of a PostgreSQL v8.0.2 fork as documented here: https://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html
Aurora versions are derivatives of many PostgreSQL versions documented here: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Updates.20180305.html
PostgreSQL will be whatever version it is.
I suspect the escape handling in your string literals is an artifact of the base PostgreSQL version, i.e. Redshift and PosgreSQL v 8.0.2 will likely do the same thing.
I hope this helps,
-Kurt
Hi klarson,
Thank you. You right.
I checked on postgres v8.0.2 and, in fact, '' is handled differently than with postgres 10.
Best regards,
pby
Relevant content
- asked 2 years ago
- Accepted Answerasked 3 months ago
- asked 5 years ago
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 4 months ago
- AWS OFFICIALUpdated a year ago