create operator problem

Поиск
Список
Период
Сортировка
От Vazsonyi Peter[ke]
Тема create operator problem
Дата
Msg-id Pine.A32.3.96.980424151938.14017C-100000@kornel.szif.hu
обсуждение исходный текст
Ответы Re: [HACKERS] create operator problem  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
Hello!

I use an external function in postgres and here i try create operator for
like with regional character support ::

-----< Cut begin
create function mylike(text,text) returns bool
as '/home/vip/neko/tudakozo/comp.so' language 'c';
CREATE
select mylike('Jeno','Jen�'),mylike('aJenO','Jen�'),mylike('fJeNof','Jen�'),
       mylike('JEn�ke','Jen�');
mylike|mylike|mylike|mylike
------+------+------+------
t     |t     |t     |t
(1 row)

select 'f:', mylike('asd','fds');
?column?|mylike
--------+------
f:      |f
(1 row)

-- It works

drop operator ~~ (text,text);
DROP
create operator ~~ (leftarg=text,rightarg=text,procedure=mylike);
CREATE
select 'this will be true'::text ~~ 'true';
?column?
--------
f
(1 row)
-- it seems not ;(
-----< Cut end

I'm not a realy postgres guru, but whith postgres 6.2 can i use this
function as operator too. If that was a bug, this letter is a bug report,
but if it isn't please help me!  The used postgres's vn: 6.3-2, it runs on a
linux (RH4.2;i386 + updates)

sprintf         ("`-''-/").___..--''"`-._            Error In
("%|s",          `6_ 6  )   `-.  (     ).`-.__.`)    Loading Object
"Petike"         (_Y_.)'  ._   )  `._ `. ``-..-'     line:3
/* Neko */     _..`--'_..-_/  /--'_.' ,'             Before /*Neko*/
 );           (il),-''  (li),'  ((!.-'     see: http://lsc.kva.hu


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: [HACKERS] linux, bsd, i386-solaris and univel shared libraries.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Re: [INTERFACES] retrieving varchar size