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)
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=>