PostgreSQL Utility Functions

Contains the following functions:

• y_bytea_to_hex(bytea) returns text. Shorthand for encode( byteaval, 'hex' ).

Examples:

% select y_bytea_to_hex( y_uuid_generate_random() );
          y_bytea_to_hex
----------------------------------
 7cafe29ebe7e4c10b82d7e9be279119e

Not terribly useful code, I know; but this is how I got my feet wet, so it has sentimental value. Someday other more interesting functions may live here. Worth a look-see if you'd like to see an example of the basic PostgreSQL programming framework that forms the basis of more sophisticated work.

More Yellowbank Code.