[BUGS] Bug in SQL functions that use a NULL parameter directly

2001-01-13 Thread Michael Richards
Hi. I'm using 7.0.3 and I've found a bug: create table test(value int4); create function testfunc(int4) RETURNS bool AS 'SELECT count(*)>0 AS RESULT FROM test where value= $1' language 'SQL'; So I want this function to return true when it finds the specified value in the t

Re: [BUGS] JDBC Driver Authentication Bug

2001-01-13 Thread Peter Mount
Sorry for the delay. What is the setting in pg_hba.conf? It sounds like this is set to trust which would produce this affect. Peter - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, December 16, 2000 4:04 AM Subject: [BUGS] JDBC Driver Authentication