CREATE OR REPLACE FUNCTION earth() RETURNS float8

LANGUAGE SQL IMMUTABLE

AS 'SELECT\'6378168\'::float8';

AS 'SELECT''6378168''::float8';

-- Astromers may want to change the earth function so that distances will be

-- returned in degrees. To do this comment out the above definition and

-- crlf

select encode(pgp_sym_decrypt_bytea(

pgp_sym_encrypt('1\n2\n3\r\n', 'key', 'convert-crlf=1'),

pgp_sym_encrypt(E'1\n2\n3\r\n', 'key', 'convert-crlf=1'),

'key'), 'hex');

encode

----------------------

-- conversion should be lossless

select encode(digest(pgp_sym_decrypt(

pgp_sym_encrypt('\r\n0\n1\r\r\n\n2\r', 'key', 'convert-crlf=1'),

pgp_sym_encrypt(E'\r\n0\n1\r\r\n\n2\r', 'key', 'convert-crlf=1'),

'key', 'convert-crlf=1'), 'sha1'), 'hex') as result,

encode(digest('\r\n0\n1\r\r\n\n2\r', 'sha1'), 'hex') as expect;

encode(digest(E'\r\n0\n1\r\r\n\n2\r', 'sha1'), 'hex') as expect;

result | expect

------------------------------------------+------------------------------------------

47bde5d88d6ef8770572b9cbb4278b402aa69966 | 47bde5d88d6ef8770572b9cbb4278b402aa69966

select encode(pgp_sym_decrypt_bytea(

pgp_sym_encrypt('1\n2\n3\r\n','key','convert-crlf=1'),

pgp_sym_encrypt(E'1\n2\n3\r\n','key','convert-crlf=1'),

'key'),'hex');

select encode(digest(pgp_sym_decrypt(

pgp_sym_encrypt('\r\n0\n1\r\r\n\n2\r','key','convert-crlf=1'),

pgp_sym_encrypt(E'\r\n0\n1\r\r\n\n2\r','key','convert-crlf=1'),

'key','convert-crlf=1'),'sha1'),'hex')as result,

encode(digest('\r\n0\n1\r\r\n\n2\r','sha1'),'hex')as expect;

encode(digest(E'\r\n0\n1\r\r\n\n2\r','sha1'),'hex')as expect;