Re: [GENERAL] libpq: bind message supplies 2 parameters, but prepared statement requires 1

2006-07-02 Thread Martijn van Oosterhout
On Sun, Jul 02, 2006 at 11:17:12PM +0200, Alexander Farber wrote: > However when I try to execute the latter query by my C-program, > then it fails, saying that my bind command supplies 2 arguments > (yes, that's true), but the prepared statement requires 1 argument > (why 1? I don't understand)

[GENERAL] libpq: bind message supplies 2 parameters, but prepared statement requires 1

2006-07-02 Thread Alexander Farber
Hello, these 2 statements work fine for me on the psql-prompt: punbb=> select id, username, md5('deadbeef' || password) from users where id = 7; id | username | md5 +--+-- 7 | Alex | b962415469222eeb31e739c3afbc8a4a (1 row) punbb=>