Re: [GENERAL] Getting last inserted SERIAL

2003-09-01 Thread Dennis Björklund
On Sun, 31 Aug 2003, mgarriss wrote: > First thought is "SELECT CURRVAL('test_id_seq');" but this assumes that > there is only one connection inserting into this table, bad assumption. That is what you should use, and it works for concurrent sessions. It's all described in the manual: http:/

Re: [GENERAL] Index usage

2003-08-26 Thread Dennis Björklund
On Mon, 25 Aug 2003, Pedro Alves wrote: > The querys below are exactly the same but refer to different months. > One case uses indexes, the other doesn't. > > Is there anything I can do? Increasing index mem size? Run "vacuum analyze". The planner seems to think that one of the queries

Re: [GENERAL] Sorting Problem

2003-08-14 Thread Dennis Björklund
On Tue, 12 Aug 2003, Maksim Likharev wrote: > If you are talking about everything that lies under so called LATIN-1 ( > ISO-8859-1 ) en_US encapsulates ( at least suppose to ) all those > sorting rules, do not remember about accents tho. It does not work like that. Different countries in europe t

Re: [GENERAL] problem with timeofday() function in cvs PostgreSQL

2003-08-14 Thread Dennis Björklund
On Fri, 8 Aug 2003, Pavel Stehule wrote: > In this version I can't convert returned value to time. timeofday() return > text. I need convert to timestamp before. It is normal behavior? I > expected timestamp as returned type. It is documented to return a string for historical reasons: http://w