Re: [SQL] inverse of "day of year"

2004-03-22 Thread Dana Hudes
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

Re: [SQL] could not create shared memory segment: Invalid argument

2004-03-16 Thread Dana Hudes
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

Re: [SQL] Import from Ms Excel

2004-03-16 Thread Dana Hudes
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

Re: [SQL] User defined types -- Social Security number...

2004-03-01 Thread Dana Hudes
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

Re: [SQL] bytea or blobs?

2004-02-18 Thread Dana Hudes
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

Re: [SQL] bytea or blobs?

2004-02-15 Thread Dana Hudes
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

Re: [SQL] Re: [ADMIN] 7.0.2 questions on encoding and compilation

2000-09-06 Thread Dana Hudes
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

[SQL] Re: [ADMIN] 7.0.2 questions on encoding and compilation

2000-09-05 Thread Dana Hudes
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