Re: [GENERAL] Return equal number of rows with same column value

2012-06-04 Thread David Johnston
On Jun 4, 2012, at 21:06, Nick wrote: > On Jun 4, 5:27 pm, Nick wrote: >> For the data... >> >> INSERT INTO test (id,val) VALUES (1,a); >> INSERT INTO test (id,val) VALUES (2,a); >> INSERT INTO test (id,val) VALUES (3,a); >> INSERT INTO test (id,val) VALUES (4,a); >> INSERT INTO test (id,val) V

[GENERAL] Return equal number of rows with same column value

2012-06-04 Thread Nick
For the data... INSERT INTO test (id,val) VALUES (1,a); INSERT INTO test (id,val) VALUES (2,a); INSERT INTO test (id,val) VALUES (3,a); INSERT INTO test (id,val) VALUES (4,a); INSERT INTO test (id,val) VALUES (5,b); INSERT INTO test (id,val) VALUES (6,b); How could I return an even amount of val?

Re: [GENERAL] Return equal number of rows with same column value

2012-06-04 Thread Nick
On Jun 4, 5:27 pm, Nick wrote: > For the data... > > INSERT INTO test (id,val) VALUES (1,a); > INSERT INTO test (id,val) VALUES (2,a); > INSERT INTO test (id,val) VALUES (3,a); > INSERT INTO test (id,val) VALUES (4,a); > INSERT INTO test (id,val) VALUES (5,b); > INSERT INTO test (id,val) VALUES (6

Re: [GENERAL] Building PostgreSQL 9.1.4 on Solaris 64-bit with gcc 4.6

2012-06-04 Thread Tom Lane
Chander Ganesan writes: > Hello, > I'm trying to build 64-bit PostgreSQL with gcc 4 on the solaris platform > - this worked fine with gcc3, but the error below seems to come up with > gcc4 . has anyone seen it before (or does anyone have a quick solution > for it?) > gmake[3]: Entering direct

[GENERAL] Building PostgreSQL 9.1.4 on Solaris 64-bit with gcc 4.6

2012-06-04 Thread Chander Ganesan
Hello, I'm trying to build 64-bit PostgreSQL with gcc 4 on the solaris platform - this worked fine with gcc3, but the error below seems to come up with gcc4 . has anyone seen it before (or does anyone have a quick solution for it?) gmake[3]: Entering directory `/src/postgres/postgresql-9.1

Re: [GENERAL] TYPE TABLE OF NUMBER

2012-06-04 Thread Thomas Kellerer
utsav, 04.06.2012 07:00: No.. in this we have to define domain and than used it . Our requirenment is like application pass the array of integer and that we have to use in PostgreSQL functions. You can pass an array directly. There is no need to define an "array type" in PostgreSQL -- Sen

Re: [GENERAL] TYPE TABLE OF NUMBER

2012-06-04 Thread utsav
No.. in this we have to define domain and than used it . Our requirenment is like application pass the array of integer and that we have to use in PostgreSQL functions. -- View this message in context: http://postgresql.1045698.n5.nabble.com/TYPE-TABLE-OF-NUMBER-tp5710983p576.html Sent from t

Re: [GENERAL] PostgreSQL 9.0.4 crashing

2012-06-04 Thread R, Abhilash (HP Software)
work_mem = 16MB not specificied the maintenance_work_mem setting in conf file(I thnk the default will work here and the value is 16MB?) Regards, Abhilash R -Original Message- From: Scott Marlowe [mailto:scott.marl...@gmail.com] Sent: Friday, June 01, 2012 8:23 PM To: R, Abhilash (HP Sof

Re: [GENERAL] Question: How do you manage version control?

2012-06-04 Thread Brendaz
So we've been reviewing our processes and working on improving them. One area we've been lacking is a procedure to version control our database functions, table changes, static data etc I'm curious how others do it. Ideally, we want it to be part of our release / build process so that we deploy fun

Re: [GENERAL] Question: How do you manage version control?

2012-06-04 Thread Chris Travers
On Fri, Jun 1, 2012 at 8:28 AM, Bryan Montgomery wrote: > Hello, > So we've been reviewing our processes and working on improving them. One > area we've been lacking is a procedure to version control our database > functions, table changes, static data etc. > > I'm curious how others do it. Ideall