Hello, PostgreSQL 8.0.x, 8.1beta3, WinXP Pro SP2
When I create a function in sql or plpgsql languages, their body text is stored in the database files with 0D 0A line ends (I checked it in a hex editor). If I create plain backup using pg_dump it generates functions with 0D 0D 0A on the end of the body lines, so when I open function definition in PGAdmin, for example, I saw function text with extra empty lines: CREATE OR REPLACE FUNCTION "foo"() RETURNS bar AS $$ select * from "bar" where bla-bla order by bla-bla; $$ LANGUAGE 'sql' VOLATILE; It's very annoy, so please fix if it's not very hard. Thank you! -- Best regards, Ivan mailto:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly