deparse altered "CREATE TABLE" statement, removed WITHOUT TIME ZONE

[divyenduz]

deparse altered "CREATE TABLE" statement, removed WITHOUT TIME ZONE

[pyramation]

so this is not technically a bug since timestamp is by definition without timezone. The AST produces the same syntax regardless of variations. Does that make sense?

https://www.postgresql.org/docs/9.1/datatype-datetime.html

So in your example, the type wasn't actually changed, but the syntax expressing it was.

[pyramation]

two queries can create the same AST. One AST, however, can only create one query.

[divyenduz]

Curious, it makes sense but I don't understand why the query fingerprint changed. Isn't finger print supposed to remain same for various syntaxes of the same query? 🤔

[divyenduz]

Thank you, but do you think that fingerprint of two queries which produce the same AST should be the same?

[pyramation]

what I'm suggesting is that, the deparser is not a bijective function, in other words It's lossy. So I think the fingerprints of two different queries should each be unique, however, once they are passed through the parser/deparser and back, they would only ever produce one query and thus one fingerprint.

[divyenduz]

Got it, thank you for taking the time to explain.