Re: [OpenFTS-general] AW: [GENERAL] tsearch2, ispell, utf-8 and german special characters

Hi! -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Markus Wollny Gesendet: Mittwoch, 21. Juli 2004 17:04 An: Oleg Bartunov Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: [OpenFTS-general] AW: [GENERAL] tsearch2, ispell, utf-8

[GENERAL] Wanted: Want to hide data by using PL/PGSQL functions

Hello, I have following problem: A user xy shouldn't have any rights to a table, but needs data from the content of the table. My idea was to setup a PL/PGSQL procedure to fetch the data from the table, so that the user only is allowed to access the procedure. I also tried using a SQL function,

Re: [GENERAL] Wanted: Want to hide data by using PL/PGSQL functions

It sounds like you want a table function: http://techdocs.postgresql.org/guides/SetReturningFunctions On Wed, 21 Jul 2004, Gellert, Andre wrote: Hello, I have following problem: A user xy shouldn't have any rights to a table, but needs data from the content of the table. My idea was to

Re: [GENERAL] Wanted: Want to hide data by using PL/PGSQL functio

Title: RE: [GENERAL] Wanted: Want to hide data by using PL/PGSQL functions This sounds like a perfect situation to use a view. With the view you can limit the data that can be seen by the user. Duane -Original Message- From: Gellert, Andre [mailto:[EMAIL PROTECTED]] Sent:

Re: [GENERAL] Wanted: Want to hide data by using PL/PGSQL functions

To return a result set use SETOF, like so CREATE FUNCTION test() RETURNS SETOF text AS ' To allow access to the tables only through a function, take a look at declaring your functions with SECURITY DEFINER CREATE FUNCTION test() RETURNS SETOF text SECURITY DEFINER AS ' .. Inside the function

[GENERAL] unsubscribe

unsubscribe ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] sorting and spaces in postgresql with en_US locale

We are having a weird problem that we ran into recently. If I use the following statements to create a test table and then run the select statement at the end, we get a very strange sort order. It appears that to do the sorting, all the spaces are removed from the strings. It would appear

Re: [OpenFTS-general] AW: [GENERAL] tsearch2, ispell, utf-8 and

On Wed, 21 Jul 2004, Markus Wollny wrote: Hi! -Urspr?ngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Markus Wollny Gesendet: Mittwoch, 21. Juli 2004 17:04 An: Oleg Bartunov Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff:

Re: [GENERAL] get first / last date of given week

Have a look at this simpler non looping version of week_start() That is a nice idea. I had to modify it a bit in order to get the same answers as my other function ... CREATE or REPLACE FUNCTION week_start2(integer, integer) RETURNS date AS ' DECLARE pyear ALIAS FOR $1; pweek

Re: [OpenFTS-general] AW: [GENERAL] tsearch2, ispell, utf-8 and german special characters

Hi! ts2test=# select * from ts_debug('Jeden Tag wird man ein bisschen weiser'); ts_name | tok_type | description | token | dict_name | tsvector +--+-+--+-+ default_german | lword| Latin word | Jeden|

Re: [GENERAL] sorting and spaces in postgresql with en_US locale

On Wed, 2004-07-21 at 20:58, Chris Kratz wrote: We are having a weird problem that we ran into recently. If I use the following statements to create a test table and then run the select statement at the end, we get a very strange sort order. It appears that to do the sorting, all the

Re: [GENERAL] Indexes and Tables: Growth and Treatment

On Jul 18, 2004, at 6:46 PM, Matthew T. O'Connor wrote: Regular vacuum will (almost) never return your table to it's minimum size. I don't think it's unreasonable for a table that is 4MB after a vacuum full, to grow to 11MB, especially if it's a very active table. That's good to know. The