Re: [SQL] select within aggregate?

2005-05-07 Thread Vortex
On Fri, 6 May 2005 07:49:23 -0500 Bruno Wolff III [EMAIL PROTECTED] wrote: You could use max(ts) as long as you can have two requests occur at the same time. This might be a reasonable assumption, but it might have been better to include a sequence so that each record would be guaranteed to

Re: [SQL] encoding

2005-05-07 Thread Aarni Ruuhimäki
Hi, In my experience , I think your best bet and an all-around good general encoding to use is latin1, which copes with l'accent egys graves, umlauts, harasoos and others. Not so sure about the M$-import stuff though. Or asp or .net. Read the Gates Private Licence ... You might also want

Re: [SQL] Discordance between the way select is called.

2005-05-07 Thread Stephan Szabo
Hi, I have a java app that uses hibernate to do queries. One query on a 6.5 millions records takes about 15 seconds while the same one (take from the sql that shows in the consol - I configured hibernate to show_sql) takes about 50 ms when done with pgadmin3. We could answer better with

Re: [SQL] encoding

2005-05-07 Thread Peter Eisentraut
Aarni Ruuhimäki wrote: You might also want (re?)configure your Pg-system with --enable-locale and set your preferred locale and db default encoding in initdb to suit your needs, in order to have alphabetical sortings etc. work ok. If you're still using a PostgreSQL version that has the