Can someone else verify if this is a bug?

[Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx>]

Hi,
I think there might be a bug in the built in function pg_get_viewdef.

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, '
','')

The returned def gets a line break where the \r should be.

I have verified this in Lightning Admin and PG Admin III, just wanted a 
second opinion.

I apologize if this is already known.

Thanks,

Tony





---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings