Re: [GENERAL] Going crazy comparing bytea columns

2006-03-01 Thread Michael Fuhr
On Wed, Mar 01, 2006 at 10:40:39AM -0800, [EMAIL PROTECTED] wrote: > I am using npgsql with C# to insert a bytea value into a > column which will serve as an encrypted password. This works > well. However, when I retrieve the value, it is different. Different how? Without knowing more I'd wonder

Re: [GENERAL] Going crazy comparing bytea columns

2006-03-01 Thread Tom Lane
[EMAIL PROTECTED] writes: > I am using npgsql with C# to insert a bytea value into a > column which will serve as an encrypted password. This works > well. However, when I retrieve the value, it is different. > In other words, "select pwd from table where pwd like @pwd" > does not work. Why are y

[GENERAL] Going crazy comparing bytea columns

2006-03-01 Thread scomp
Hi, I am new to Postgresql, so pls be patient. I am using npgsql with C# to insert a bytea value into a column which will serve as an encrypted password. This works well. However, when I retrieve the value, it is different. In other words, "select pwd from table where pwd like @pwd" does not work.