[GENERAL] Grouping aggregate functions

2006-04-02 Thread Richard Connamacher
Hey all, I'm new on this list, and have been playing with Postgres a lot this week. (Love it, by the way.) I've got a question, if anyone can help me out. I know how to use an aggregate function to, say, find the lowest price ever listed for a product. I also know how to combine that with

Re: [GENERAL] Grouping aggregate functions

2006-04-03 Thread Richard Connamacher
finally worked is this: SELECT avg(minprice) FROM (SELECT min(price) AS minprice FROM weekly_supply_prices GROUP BY month) AS minprice_table; Thanks again, Rich On Apr 2, 2006, at 4:51 AM, Martijn van Oosterhout wrote: On Sun, Apr 02, 2006 at 04:03:03AM -0700, Richard Connamacher wrote

[GENERAL] UTF-8 question.

2004-09-16 Thread Richard Connamacher
I'm new to PostgreSQL, and from the looks of it, it's a great database, and I'll be using more of it in the future. I had a quick question if anyone could clear this up. The documentation for PostgreSQL (version 7.1, the version this server is using) says that it supports multibyte character encod

Re: [GENERAL] UTF-8 question.

2004-09-16 Thread Richard Connamacher
queries. Many thanks for the clarification, Rich > > On Sep 17, 2004, at 9:39 AM, Richard Connamacher wrote: > > > UTF-8 is the 8-bit version of Unicode. > > The multibyte version of Unicode is UTF-16. > > UTF-8 encodes characters with varying numbers of bytes, not just