is redundant, but this is how
windows clock format is set up in few of our customers, and this is what
is sent to postgres. We will alter this presentation through our client
program, but is there a way to make postgres accept values like these?
Postgres is version 8.2.3 on fedora 7 (64-bit).
Dragan
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/ HH24:MI:SS')
- 2007-11
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 - client
Tomi NA wrote:
On 6/30/06, Martijn van Oosterhout kleptog@svana.org 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
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:
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 desire to
choose
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 scan if your joining
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
Dragan
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
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
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
11 matches
Mail list logo