Re: [GENERAL] Weird datetime problem

I was thinking that it may be a timezone thing. Some of the dates are of CDT and some are CST. I live in Dallas which is the Central Time Zone. I just don't understand. I seem to have alot of time/date problems with Postgres. Maybe its just me. Actually, now I see what is going on. I define

Re: [GENERAL] Weird datetime problem

It's not a timezone problem is it? Did the dates get re-loaded correctly? Andy Lewis wrote: > > I have 2 tables both of which have a datetime field and both have an > identifier of date_submitted. > > I've been using(via PHP) a query of the following for a month or so with > no problem: > > se

[GENERAL] More problems with arrays !!!!!

Hi, I tried to create a function in C that receive an array X like argument, and return ane element of him. Here is the C code -> #include #include int4 array_1(int4 x[]){ return(x[1]); } int4 array_2(int4 *x){

[GENERAL] Weird datetime problem

I have 2 tables both of which have a datetime field and both have an identifier of date_submitted. I've been using(via PHP) a query of the following for a month or so with no problem: select count(*) from mytable1 where date_submitted > 'today'::datetime and select count(*) from mytable2 where

[GENERAL] Int8: problems

Hello Thomas, I installed the whole PostgreSQL-bundle, including int8, out of the box and now I'm trying to use the int8-datatype. It looks as if I can get a value in the table but not in a 'normal' way out of it. I tried your testscript itest.sql and below you see it's output. Another (?) pr

Re: [GENERAL] pg_database corrupted(?) If so, what do I do????

I was about to say: I tried to SIMPLY update the pg_database and it worked!. I have a tendency to overlook the simple solutions. Thanks for ALL your help. Maybe someday I'll be smart enough to help you. Jonny -Original Message- From: Herouth Maoz <[EMAIL PROTECTED]> To: Jonny Hino

Re: [GENERAL] pg_database corrupted(?) If so, what do I do????

At 18:03 +0300 on 11/05/1999, Jonny Hinojosa wrote: > No, but I have tried to figure out how to do just that. I have found no way > to effect these updates. So which part of the docs did I sleep through??? > > All help is GREATLY appreciated. I can't test any advice I give on my own system, a

Re: [GENERAL] pg_database corrupted(?) If so, what do I do????

No, but I have tried to figure out how to do just that. I have found no way to effect these updates. So which part of the docs did I sleep through??? All help is GREATLY appreciated. Jonny -Original Message- From: Herouth Maoz <[EMAIL PROTECTED]> To: Jonny Hinojosa <[EMAIL PROTECTED]>

[GENERAL] VB6 ODBC PostgreSQL accessing failure.

I have encountered a problem accessing my PostgreSQL database. I am accessing via VB6 using an ADODC/ODBC link with 32 columns in a postgresql table. If I access directly it fails with an 'unexpected failure' when attempting to use a drop down field list from a fields properties. If I use all t

[GENERAL] Win32 port

Hi all, Is someone have installed and tested the cygnus port of PostgreSQL to Win32 platform ? Is there's something to know about before installing ? Is it working well ? For others who don't know about this port I give you the URL http://www.student.uni-koeln.de/cygwin/Distribution/Binary/?it

RE: [GENERAL] pg_database corrupted(?) If so, what do I do????

At 22:26 +0300 on 10/05/1999, Jonny Hinojosa wrote: > The last 2 entries have been corrupted. How do I (can I) correct these > entries ?? Have you tried logging into psql (template1) as postgres and updating the pg_database table? Herouth -- Herouth Maoz, Internet developer. Open Univers