[SQL] fail to compare between bytea output in plpgsql

2004-07-20 Thread Peter Wang
I have a function and am using cursor. All the columns I select in the cursor clause are BYTEA datatype. I need to compare the after-fetch-value for two BYTEA columns which is temp2 and temp3 shown as below. I don't think I can compare it because there is no record in temp table which I use

[SQL] BYTEA output presentation

2004-07-16 Thread Peter Wang
, how ? Or do you know any third party tool or script which can output the hexadecimal or octal format for PostgreSQL's BYTEA datatype ? Your help is appreciated. Thank you. Peter Wang, ---(end of broadcast)--- TIP 3: if posting/reading through