Re: [BUGS] my schema + sql function

2003-02-19 Thread Tom Lane
Marek "Wróbel" <[EMAIL PROTECTED]> writes: > In my schema : "my" I create sql function > CREATE OR REPLACE FUNCTION my.my_foo(int4) RETURNS varchar AS ' > select k.k_dupa ||coalesce( '' ['' || k.k_number || '']'' ,) > from kont k > where k_id = $1; > ' LANGUAGE 'sql'; > table kont

[BUGS] my schema + sql function

2003-02-18 Thread Wróbel
Hi, In my schema : "my" I create sql function CREATE OR REPLACE FUNCTION my.my_foo(int4) RETURNS varchar AS ' select k.k_dupa ||coalesce( '' ['' || k.k_number || '']'' ,) from kont k where k_id = $1; ' LANGUAGE 'sql'; table kont is in schema public. Everythink working ok, but wh