[HACKERS] FOR UPDATE lock problem ?

2006-04-25 Thread REYNAUD Jean-Samuel
commit; Then finaly on bk2: id_session 403 404 (2 rows) => But the rows were updated by the other backend so to_date field is not null for these tuples...However these tuples are in the result produced by the backend #2... If I remove the idx_session_

Re: [HACKERS] Function call with offset and limit

2005-12-22 Thread REYNAUD Jean-Samuel
keyword) > FROM (SELECT * FROM tag OFFSET 5000 LIMIT 1) > ; > > ? > > This should probably have been on -general, btw. > > On Wed, Dec 21, 2005 at 06:44:33PM +0100, REYNAUD Jean-Samuel wrote: > > Hi all, > > > > We need to find a solution for a stran

[HACKERS] Function call with offset and limit

2005-12-21 Thread REYNAUD Jean-Samuel
ch more than needed. But, If I do: test=# select *,(select test_func(1)) from tag offset 5000 limit 1; My function is called only once. Is there any work around ? Thanks -- REYNAUD Jean-Samuel <[EMAIL PROTECTED]> Elma ---(end of broadcast)--