printing a value of a variable in postgresql

Sunday, May 4, 2014

Hello guys I have a postgresql function



CREATE OR REPLACE FUNCTION fixMissingFiles() RETURNS VOID AS $$
DECLARE
deletedContactId integer;
BEGIN
SELECT INTO deletedContactId contact_id FROM myContacts WHERE id=206351;

-- print the value of deletedContactId variable to the console

END;
$$ LANGUAGE plpgsql;


How can I print the value of the deletedContactId to the console?







http://ift.tt/1fJ1YQc