Re: [GENERAL] Timestamp comparison with string in some special cases

Sam Mason wrote: On Mon, Nov 19, 2007 at 04:52:10PM +0100, Dragan Matic wrote: select * from table where timestamp_column < '11/19/2007 15:46:09 PM' Maybe the to_timestamp() function would help you: SELECT to_timestamp('11/19/2007 15:46:09 PM','MM/DD/Y

[GENERAL] Timestamp comparison with string in some special cases

ostgres is version 8.2.3 on fedora 7 (64-bit). Dragan Matic -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] different sort order in windows and linux version

Tom Lane wrote: Dragan Matic <[EMAIL PROTECTED]> writes: I was about to say the same thing. I think that the whole point in having a portable database system is that the data inside the database should behave the _same way_ no matter what operating system database is running on -

Re: [GENERAL] different sort order in windows and linux version

Tomi NA wrote: On 6/30/06, Martijn van Oosterhout wrote: On Fri, Jun 30, 2006 at 11:56:19AM +0200, Dragan Matic wrote: > I have two postgres servers, one on linux (fedora core 5), one on > windows, both are version 8.1.4. > Not beeing able to depend on the engine to consistentl

[GENERAL] different sort order in windows and linux version

I have two postgres servers, one on linux (fedora core 5), one on windows, both are version 8.1.4. Both databases are initialized with locale Croatian and win1250 encoding. running pg_controldata on windows returns this LC_COLLATE: Croatian_Croatia.1250 LC_CTYPE:Croatian_C

[GENERAL] vacuum full taking much longer than dump + restore?

re some configuration parameters that might be misconfigured? I am using fedora core 4 with pre-built 8.1.3 rpms. Server has 2 gb of ram. Tnx in advance Dragan Matic ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your d

[GENERAL] Postgres automatically inserts chr(13) whenever chr(10) is inserted

tabase is on a linux server with SQL_ASCII encoding, clients are winXP communicating thru ODBC. Tnx in advance DRagan Matic ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index

[GENERAL] Is there a way to check which indexes are being used for a table

to see which indexes have been used on a table (and how many times) and which haven't? Statistics is turned on for a database, I can see number of sequential scans and index scans for instance, but I would like to know which indexes have been used and how many times. Tnx in advance D

[GENERAL] Is there something like Mssql GUID in PostgreSql database

We are currently migrating a database from Ms Sql server to PostgreSQL. So far replication was done using GUID (global unique identifier) fields which is MS extension. I am wondering if something similar exists in PostgreSQL? Tnx in advance Dragan ---(end of broadcas

[GENERAL] Case insensitive search

Is there a way to set up collation order to be case-insensitive? I.E. I need to have a column c with value 'ABC' and when I do a "select * from table where c = 'abc'" it finds the row with value 'ABC'. Yes, I know that I can do it with "lower()" and "upper()" functions, but is there a way to con

[GENERAL] Is Postgres broken in Red Hat 9?

Hi, there is a small problem here I have, I would appreciate any suggestion. We were using Postgres 7.2.x and later 7.3.x under Red Hat 8, and everything worked fine. Clients are working under windows and are communicating to Postgres via ODBC. This weekend we tried to upgrade to Red Hat 9