If you have the option to handle the date manipulation in Perl
use the DateTime modules. Also see Date::Calc.
A considerable amount of effort has been expended dealing with all
the nitty-gritty of time manipulation.
Use those modules , get your new date or time interval and
feed that to the dbms wi
Well, did you consider getting the value of SHMMAX?
Check with ulimit (as the postgres user).
On Tue, 16 Mar 2004, beyaNet Consultancy wrote:
> Hi,
> I have just installed the latest version of OS X panther (10.3.3) and
> am now getting the following error message:
>
> postgres$ /usr/local/pgs
Certainly you can export your spreadsheet in CSV and
it will easily go into Postgresql database (after you
create the database and its tables).
If you want something more sophisticated, a program
in e.g. Perl could use one of the various library programs
to extract data in some other-than-straight
I would represent an SSN as numeric(9,0).
an int 32 would work though.
2**31 is > 9
On Sun, 29 Feb 2004, Christopher Browne wrote:
> The world rejoiced as [EMAIL PROTECTED] (Michael Chaney) wrote:
> > Look, you're thinking way too hard on this. An SSN is a 9-digit number,
> > nothing mor
18 February 2004 06:44, Dana Hudes wrote:
> >
> > At least with base64 I have ample libraries and can convert my data
> > before sending to sql or after receiving from sql. It becomes my
> > application's issue. Mind, this bloats the data considerably.
> > escape is
I'm in the same situation. I struggled with it for days
considering various implementation issues for my application
and what I hoped to achieve. I opted to use bytea but getting the
data in and out is going to be interesting . have to use encode/decode.
However I don't have to worry about making t
RTFM for gcc
-mcpu=i686
On Wed, 6 Sep 2000, Max Pyziur wrote:
>
>
> On Thu, 31 Aug 2000, Igor N. Avtaev wrote:
>
> > [EMAIL PROTECTED] wrote:
> >
> > > Currently, I'm using the the 7.0.2 rpms from the postgresql.org
> > > on a RH6.2 install.
> > >
> > > I have a few questions on it and the u
I have compiled for i686 by hacking up my RPM compile environment.
On Wed, 30 Aug 2000 [EMAIL PROTECTED] wrote:
> Currently, I'm using the the 7.0.2 rpms from the postgresql.org
> on a RH6.2 install.
>
> I have a few questions on it and the use of the -E flag.
>
> 1 - can 7.0.2 be optimized fo