Re: [GENERAL] Re: [HACKERS] My new job

2000-10-11 Thread Matthew N. Dodd
On Wed, 11 Oct 2000, Adam Lang wrote: > Ah but remember... what is a "better RDBMS" to a company may be > different than one for the open source community. I'm not sure I see that... The one place where GB can get burned is if they spend lots of time/money implementing a feature and then attempt

Re: [GENERAL] Comments on earlier age() post.

2000-10-11 Thread Tom Lane
"Mitch Vincent" <[EMAIL PROTECTED]> writes: > hhs=# SELECT age('Sun Dec 03 08:00:00 2000 EST','Tue Oct 10 08:00:00 2000 > EDT') as esec; > esec > > @ 1 mon 24 days 1 hour > (1 row) > Ok, but if I turn right around and add that value back , I get : > hhs=# SELE

Re: [GENERAL] Index on substring?

2000-10-11 Thread Tom Lane
Jeff Eckermann <[EMAIL PROTECTED]> writes: > extracts=# create index c_namesum_i on customers (substr(bill_company,1,5)); > ERROR: parser: parse error at or near "1" The functional-index syntax only allows a function name applied to simple column names. You can work around this by defining a fu

Re: [GENERAL] Postgres Global Variables

2000-10-11 Thread Tom Lane
[EMAIL PROTECTED] writes: > make use of a Sybase global variable called @@rowcount. @@rowcount > represents the number of rows affected by the most recent data modification > operation (inserts, deletes and/or updates). > Is there an equivalent in Postgres? Thanks much for the help. I think th

Re: [GENERAL] postgresql 7.1

2000-10-11 Thread Tom Lane
Tim Uckun <[EMAIL PROTECTED]> writes: > What happened to outer joins? Don't you need outer joins to compete with > the big boys? They're done too ;-) regards, tom lane

Re: [GENERAL] postgresql 7.1

2000-10-11 Thread The Hermit Hacker
On Wed, 11 Oct 2000, Tim Uckun wrote: > At 11:04 PM 10/11/2000 -0300, Martin A. Marques wrote: > >On Wed, 11 Oct 2000, Asidha Luhwidyanto wrote: > > > What;s the new in Postgresql 7.1 ? > > > >TOAST and WAL > > > >I think these are big changes that will make me think about postgresql as a > >

Re: [GENERAL] postgresql 7.1

2000-10-11 Thread Tim Uckun
At 11:04 PM 10/11/2000 -0300, Martin A. Marques wrote: >On Wed, 11 Oct 2000, Asidha Luhwidyanto wrote: > > What;s the new in Postgresql 7.1 ? > >TOAST and WAL > >I think these are big changes that will make me think about postgresql as a >big time competitor against the big commercial database

Re: [GENERAL] postgresql 7.1

2000-10-11 Thread Alfred Perlstein
* Martin A. Marques <[EMAIL PROTECTED]> [001011 19:10] wrote: > On Wed, 11 Oct 2000, Asidha Luhwidyanto wrote: > > What;s the new in Postgresql 7.1 ? > > TOAST and WAL > > I think these are big changes that will make me think about postgresql as a > big time competitor against the big comme

Re: [GENERAL] postgresql 7.1

2000-10-11 Thread Martin A. Marques
On Wed, 11 Oct 2000, Asidha Luhwidyanto wrote: > What;s the new in Postgresql 7.1 ? TOAST and WAL I think these are big changes that will make me think about postgresql as a big time competitor against the big commercial database engines. WAL is a backup system. TOAST is a system for worki

Re: [GENERAL] postgresql 7.1

2000-10-11 Thread Asidha Luhwidyanto
What;s the new in Postgresql 7.1 ? Asidha Luhwidyanto "Martin A. Marques" wrote: > How far are we from seeing the version 7.1 out? > > -- > "And I'm happy, because you make me feel good, about me." - Melvin Udall > - > Martín Marq

Re: [GENERAL] postgresql 7.1

2000-10-11 Thread The Hermit Hacker
On Wed, 11 Oct 2000, Martin A. Marques wrote: > How far are we from seeing the version 7.1 out? beta starts ~Nov 1st, release in January ...

[GENERAL] postgresql 7.1

2000-10-11 Thread Martin A. Marques
How far are we from seeing the version 7.1 out? -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.

[GENERAL] Re: R: PostgreSQL book

2000-10-11 Thread Daniel Freedman
I stopped buying from and supporting Amazon.com over both their one-click patent (enforced against Barnes & Noble and now recently, very publicly, licensed to apple.com even though Bezos stated to Tim O'Reilly in a public discussion on business patents that it would be used for _defensive_ purpos

Re: [GENERAL] CREATE FUNCTION LANGUAGE C

2000-10-11 Thread Alex Pilosov
Yes, that is why only superusers have access to 'create function language c' -alex On Wed, 11 Oct 2000, Marc SCHAEFER wrote: > Hi, > > CREATE FUNCTION LANGUAGE C (and maybe others) allow to load shared > libraries. However the path can be specified arbitrarily by the user. Is > that a way for

Re: R: [GENERAL] PostgreSQL book

2000-10-11 Thread Mitch Vincent
No matter where you choose to buy it, do buy it and support Bruce, PostgreSQL and the publisher for allowing it to be electronically published!! -Mitch - Original Message - From: <[EMAIL PROTECTED]> To: "Steve Wolfe" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, October 11

[GENERAL] CREATE FUNCTION LANGUAGE C

2000-10-11 Thread Marc SCHAEFER
Hi, CREATE FUNCTION LANGUAGE C (and maybe others) allow to load shared libraries. However the path can be specified arbitrarily by the user. Is that a way for a user X to gain the UID rights of the user running the postmaster ?

Re: R: [GENERAL] PostgreSQL book

2000-10-11 Thread mjp
..not to mention that it is now Amazon's official policy to use/share personal information they now/will have on you, arguably, any way they wish: http://www.amazon.com/privacy-notice Morey Parang Oak Ridge National Lab On Wed, Oct 11, 2000 at 12:42:17PM -0600, Steve Wolfe wrote: > >

Re: R: [GENERAL] PostgreSQL book

2000-10-11 Thread Roderick A. Anderson
On Wed, 11 Oct 2000, Bruce Momjian wrote: > Wow, that is terrible. That and their "one-click" licensing patent have > made me use Barnes and Noble almost exclusively (bn.com). Actually, BN > has a much larger catalog of out-of-print books. And they are accepting pre-orders. I did mine about t

[GENERAL] Index on substring?

2000-10-11 Thread Jeff Eckermann
I thought this was possible, but searching the archives & docs I can't find any reference to it... Am I doing something wrong? jeffe@kiyoko=> psql -V psql (PostgreSQL) 7.0.0 jeffe@kiyoko=> uname -a FreeBSD kiyoko.la.verio.net 4.0-STABLE FreeBSD 4.0-STABLE #0: Thu Apr 27 10:44:07 CDT 2000 roo

Re: Re[2]: [GENERAL] Pg.pm question

2000-10-11 Thread Alex Pilosov
Then you probably didn't install the binary shared library (Pg.so) to the proper directory. On Wed, 11 Oct 2000, Kurt Miller wrote: > The code in question is Pg.pm > > The script is failing inside Pg.pm, not in the script that uses it. > > I tracked the error down to the line in Pg.pm that fa

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-11 Thread fabrizio . ermini
> > Bottom line is we're not sure what to do now. Opinions from the > floor, anyone? > >From the lowly end of the floor... for what I am concerned, I'm not worried about the involvment of the core team. Instead, I'm happy that companies like GB and Postgres Inc have been founded. I'm not a