Re: [GENERAL] Ordering and unicode

2005-11-10 Thread Michael Schuerig
On Thursday 10 November 2005 21:31, Michael Schuerig wrote: > I have a database on PostgreSQL 8.0.3 with unicode (utf-8) encoding, > client encoding is set to unicode, too. LC_COLLATE for the cluster is > [EMAIL PROTECTED] I noticed that that collation doesn't work for > tw

[GENERAL] Ordering and unicode

2005-11-10 Thread Michael Schuerig
that I'd have to re-initialize the cluster with a utf-8 collation. Is this correct? Right now I don't have access to the machine and can't check this. Michael -- Michael Schuerig Face reality and stare it down mailto:[EMAIL PROTECTED]--Jethro Tull,

[GENERAL] Learning server programming

2005-10-28 Thread Michael Schuerig
th system architecture at large. I have in mind issues such as O/R-mapping when the database isn't just a dumb data store, handling of tasks like authorization in the application or in the db server. Any recommendations where to start reading? Michael -- Michael Schuerig

Re: [GENERAL] Implementing a change log

2005-09-20 Thread Michael Schuerig
ase: languages, design and architecture, frameworks. Literature on database-server programming seems to be tied to specific products, mostly Oracle. I'd like to be wrong, of course. What are good ways to learn about these things in a free database world? Michael --

Re: [GENERAL] Implementing a change log

2005-09-18 Thread Michael Schuerig
On Monday 19 September 2005 01:29, Mike Rylander wrote: > On 9/18/05, Michael Schuerig <[EMAIL PROTECTED]> wrote: > > In my current project I have a customer requirement for > > implementing a change log. This is not just for auditing purposes, > > rather it is meant t

[GENERAL] Implementing a change log

2005-09-18 Thread Michael Schuerig
hich approaches should I take into consideration? Michael -- Michael Schuerig Face reality and stare it down mailto:[EMAIL PROTECTED]--Jethro Tull, Silver River Turning http://www.schuerig.de/michael/ ---(end of broadcast)

Re: [GENERAL] Setting date format for a single output column?

2005-09-13 Thread Michael Schuerig
On Wednesday 14 September 2005 02:32, Alvaro Herrera wrote: > On Wed, Sep 14, 2005 at 02:12:34AM +0200, Michael Schuerig wrote: > > I'd like to get date columns in the results of a query in the > > appropriate format (EUROPEAN, GERMAN). I've tried to set DATESTYLE > &g

[GENERAL] Setting date format for a single output column?

2005-09-13 Thread Michael Schuerig
to set the date style/format on a per column basis for the result returned by a SELECT statement? Michael [*] Rails/ActiveRecord. The problem actually lies still deeper in Ruby's parsedate standard lib method. -- Michael Schuerig Thinking is trying to make up mai