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
|
Список | 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 по дате отправления: