Re: [GENERAL] Sorting nulls and empty strings together

2008-04-28 Thread Dennis Muhlestein
Andrus wrote: User interface need to show nulls as empty strings. PostgreSQL sorts nulls after all data. create temp table test ( testcol char(10) ); insert into test values ( null); insert into test values ( 'test'); insert into test values ( ''); select * from test order by testcol; This conf

[GENERAL] Cybercluster

2007-11-02 Thread Dennis Muhlestein
I saw the announcement for a multi-master replication system on the Announcement list. What are your thoughts on this product? Has anyone tried it? The cybercluster link: http://www.postgresql.at/english/downloads_e.html -Dennis ---(end of broadcast)-

Re: [GENERAL] Timestamp from an OID?

2007-09-12 Thread Dennis Muhlestein
A. Kretschmer wrote: am Wed, dem 12.09.2007, um 15:41:44 +0200 mailte A. Kretschmer folgendes: am Wed, dem 12.09.2007, um 7:32:45 -0600 mailte Dennis Muhlestein folgendes: I've been passively collecting data for a few months. I realized, after a while, that I never added a timestamp c

[GENERAL] Timestamp from an OID?

2007-09-12 Thread Dennis Muhlestein
I've been passively collecting data for a few months. I realized, after a while, that I never added a timestamp column to the table the data is being stored in. I've since added that. Is there a way to find out when the previous rows were inserted? There is a serial integer for the primary

[GENERAL] production java/postgresql

2001-05-22 Thread Dennis Muhlestein
I'm interested in finding companies that use java and postgres in a production environment. If anyone knows of any url's I could visit or has experience with this in their own company, I'd love to hear about it. Thanks ---(end of broadcast)--- T

[GENERAL] Java Access to Postgresql

2001-05-18 Thread Dennis Muhlestein
Being new to postresql, I'm looking in to different ways of accessing the database from java. I'm interested in accessing postgres through a jdbc driver. The driver from postgres does not seem to be fully implemented (ie: Updatable ResultSets). I've also tried configuring an odbc datasource an