Tom Lane <[EMAIL PROTECTED]> writes: > Manuel Sugawara <[EMAIL PROTECTED]> writes: > > Hi, I have found what I thing is a quite annoying behaviour of > > Postgres (psql). When you type (and ask for complation) for some > > string that has some characters not in the ASCII encoding it requires > > a double quote on it, however if you don't put those double quotes > > around it, you can still execute the query. > > ... in other words, it doesn't require the double quotes. I don't see > the value of being more restrictive. Why is this annoying?
It's because you can't complete without the double quote, so, select something.fo<tab> doesn't complete if you have only foó as the only completion whereas select something ."fo does. Regards, Manuel. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])