On Dec 27, 2004, at 6:42 AM, Kaloyan Iliev Iliev wrote:
CREATE OR REPLACE FUNCTION "int" (boolean) RETURNS integer AS' select CASE WHEN $1 THEN 1 ELSE 0 END 'LANGUAGE 'sql';
The problem is that you have quoted the function name as "int". You should only do this when you want to force the exact case of the name. When you do it this way, you have to use double quotes when you refer to the identifier:
select "int"('t'::boolean); int ----- 1 (1 row)
So in this case you probably want to call your function int -- without quotes. By default, PostgreSQL folds the names to lowercase.
Best,
John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
