Re: [SQL] Insert into a date field

2007-02-05 Thread Hiltibidal, Robert
Try this: '1/9/1963' I'm interpreting your date to be January 9, 1963. -R From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ezequias Rodrigues da Rocha Sent: Friday, February 02, 2007 7:08 AM To: pgsql-sql@postgresql.org Subject: [SQL] I

Re: [SQL] Index Anding

2007-02-05 Thread Hiltibidal, Robert
I will investigate this. Our gcc is only able to compile 32 bit. I think I will have to see if I can get/compile a 64 bit gcc I appreciate the help! -R -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Browne Sent: Thursday, February 01, 2007 4:45

[SQL] Compilation Error AIX

2007-02-05 Thread Hiltibidal, Robert
I am getting this error make -C port all make[3]: Entering directory `/db2/logs/downloads/postgres/postgresql-8.2.1/src/backend/port' gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -I../../../src/include -c

[SQL] Compilation errors

2007-02-05 Thread Hiltibidal, Robert
Is this a good group to post compilation errors to? PRIVILEGED AND CONFIDENTIAL This email transmission contains privileged and confidential information intended only for the use of the individual or entity named above. If the reader of the email is not the intended recipient or the employee

Re: [SQL] Index Anding

2007-02-05 Thread Hiltibidal, Robert
This is excellent information Thank you! -Original Message- From: Andrew Sullivan [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 9:53 AM To: Hiltibidal, Robert; pgsql-sql@postgresql.org Subject: Re: Index Anding You probably want to take these questions to the -general

[SQL] Index Anding

2007-02-05 Thread Hiltibidal, Robert
Good Morning I am considering postgres for a project I am currently using DB2 for. The database is a 200 gb database on db2. The os is AIX 5.2 on a p5 series box with 2 processors and 7 gb ram. I have 300 gb in local scsi mirrored and 300 gb of shark disk raid5. The database

[SQL] Index ANDing & Index ORing

2007-02-05 Thread Hiltibidal, Robert
Does postgres have support for index ANDing and index ORing? Thanks! -Rob PRIVILEGED AND CONFIDENTIAL This email transmission contains privileged and confidential information intended only for the use of the individual or entity named above. If the reader of the email is not the int