Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx> writes: > Basically if you have a function in your view SQL like this: > replace(address1, '\r', '') > pg_get_viewdef is returning the view definition with the \r replaced by > it's ASCII code which causes this: > replace(address1, ' > ','') This is not incorrect, if the original was interpreted under escape-string syntax. Perhaps you meant to type \\r ? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
