tsearch2() trigger and domain types...
От | Michael D. Stemle, Jr. |
---|---|
Тема | tsearch2() trigger and domain types... |
Дата | |
Msg-id | 200706181610.00270.manchicken@notsosoft.net обсуждение исходный текст |
Ответы |
Re: tsearch2() trigger and domain types...
|
Список | pgsql-sql |
Okay, so I have an interesting problem that I'm having a hard time figuring out. For standardization in my database I use a domain (login_t) for my login column in my profile table. I'm trying to use the tsearch2() trigger to index several columns, including the login column, into a column called "search_index." So I added the trigger as attached with the hope that it would do just that. Well, here's what I get upon every update and insert to the profile table: WARNING: TSearch: 'login' is not of character type I've tried casting and such, but nothing seems to work. Anybody got any ideas? Thanks in advance. -- ~ Michael D. Stemle, Jr. <>< (A)bort, (R)etry, (I)nfluence with large hammer 09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0 Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html
В списке pgsql-sql по дате отправления: