Andrew Dunstan <[EMAIL PROTECTED]> writes:
I'd like to see pg_dump use this mechanism for quoting, at least for function bodies. I guess it could retrieve the text and then keep generating delimiters until it found one that didn't occur inside the text.
Right, that was what I had in mind.
great
We already do - you can't begin an identifier with a digit. I'm not dogmatic about it, though. I'd be more than happy with just what you proposed.
Maybe for that purpose we could allow underscores as well as letters - I don't think that should introduce any extra ambiguities. Alternatively, or as well, maybe leading and trailing digits could be disallowed, but embedded digits could be allowed. IOW let's be as liberal as possible without breaking things.
<shrug> I'd prefer to keep the rules as simple as possible. No particular objection to underscores, but allowing digits in only some places seems confusing.
cheers
andrew
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match