Re: Inserting multiple values, was Re: [GENERAL] solaris tarballs and pl/java

2010-04-15 Thread Scott Marlowe
On Thu, Apr 15, 2010 at 1:49 PM, Raymond O'Donnell wrote: > On 15/04/2010 20:44, Ozz Nixon wrote: >> Would this syntax work in PostgreSQL? >> >> |INSERT INTO MyTable (FirstCol, SecondCol) >> VALUES ('First',1), >> || ('||Second||',2),| >> | ('||Third||',3),| >> | ('||Fourth||',4),| >> | ('||Fifth|

Re: [GENERAL] solaris tarballs and pl/java

2010-04-15 Thread John R Pierce
Andy Colson wrote: On 4/15/2010 11:59 AM, John R Pierce wrote: The tarball for 64bit 8.4.3 on Solaris Sparc is missing some ./pgxs/... files I seem to need to build pl/java. they exist in the 32bit version but at least of them, Makefile.global, appears quite build specific. So, it seem to be

Re: [GENERAL] solaris tarballs and pl/java

2010-04-15 Thread John R Pierce
Alvaro Herrera wrote: ... 8.4.3 ... I'm jumping sideways and trying a different attack on my actual problem, which is building pl/java HEAD for 64bit solaris sparc w/ 8.4.3 and JDK 1.5.0_23... rather than building the entire postgres tree, I replicated the couple missing files from the 32bit

Re: [GENERAL] solaris tarballs and pl/java

2010-04-15 Thread Andy Colson
On 4/15/2010 11:59 AM, John R Pierce wrote: The tarball for 64bit 8.4.3 on Solaris Sparc is missing some ./pgxs/... files I seem to need to build pl/java. they exist in the 32bit version but at least of them, Makefile.global, appears quite build specific. So, it seem to be painful to compile t

Re: [GENERAL] solaris tarballs and pl/java

2010-04-15 Thread Alvaro Herrera
John R Pierce wrote: > Tom Lane wrote: > >John R Pierce writes: > >>getting this error from thte ./configure: > >>configure:16808: error: cannot compute sizeof (off_t) > > > >That's pretty weird. Look into the config.log output to see why that > >particular test program is failing. (The rele

Re: [GENERAL] solaris tarballs and pl/java

2010-04-15 Thread John R Pierce
Tom Lane wrote: John R Pierce writes: getting this error from thte ./configure: configure:16808: error: cannot compute sizeof (off_t) That's pretty weird. Look into the config.log output to see why that particular test program is failing. (The relevant bit will probably be a few

Re: [GENERAL] solaris tarballs and pl/java

2010-04-15 Thread Alvaro Herrera
Ozz Nixon escribió: > Would this syntax work in PostgreSQL? > > |INSERT INTO MyTable (FirstCol, SecondCol) > VALUES ('First',1), > || ('||Second||',2),| > | ('||Third||',3),| > | ('||Fourth||',4),| > | ('||Fifth||',5)|| Yes, it works (without all those funny || though) -- Alvaro Herrera

Inserting multiple values, was Re: [GENERAL] solaris tarballs and pl/java

2010-04-15 Thread Raymond O'Donnell
On 15/04/2010 20:44, Ozz Nixon wrote: > Would this syntax work in PostgreSQL? > > |INSERT INTO MyTable (FirstCol, SecondCol) > VALUES ('First',1), > || ('||Second||',2),| > | ('||Third||',3),| > | ('||Fourth||',4),| > | ('||Fifth||',5)|| > | > Inserting 5 rows in a single Insert? (I am trying to i

Re: [GENERAL] solaris tarballs and pl/java

2010-04-15 Thread Ozz Nixon
Would this syntax work in PostgreSQL? |INSERT INTO MyTable (FirstCol, SecondCol) VALUES ('First',1), || ('||Second||',2),| | ('||Third||',3),| | ('||Fourth||',4),| | ('||Fifth||',5)|| | Inserting 5 rows in a single Insert? (I am trying to implement this solution across many different backends) w

Re: [GENERAL] solaris tarballs and pl/java

2010-04-15 Thread Tom Lane
John R Pierce writes: > getting this error from thte ./configure: > configure:16808: error: cannot compute sizeof (off_t) That's pretty weird. Look into the config.log output to see why that particular test program is failing. (The relevant bit will probably be a few hundred lines before th

Re: [GENERAL] solaris tarballs and pl/java

2010-04-15 Thread John R Pierce
John R Pierce wrote: Last night, I started trying to piece together the environment for ./configure for postgres based on what pg_config gives me, but it aborted pretty early with missing stuffs... by then it was 1am and I was fried so I am taking a fresh look this morning... k, I'm already

Re: [GENERAL] solaris tarballs and pl/java

2010-04-15 Thread John R Pierce
Greg Smith wrote: John R Pierce wrote: The tarball for 64bit 8.4.3 on Solaris Sparc is missing some ./pgxs/... files I seem to need to build pl/java. they exist in the 32bit version but at least of them, Makefile.global, appears quite build specific. Yeah, it seemed pretty obvious from the

Re: [GENERAL] solaris tarballs and pl/java

2010-04-15 Thread Greg Smith
John R Pierce wrote: The tarball for 64bit 8.4.3 on Solaris Sparc is missing some ./pgxs/... files I seem to need to build pl/java. they exist in the 32bit version but at least of them, Makefile.global, appears quite build specific. Yeah, it seemed pretty obvious from the error you were runn