Re: [HACKERS] Retiring from the Core Team

2017-01-12 Thread Roberto Mello
On Wed, Jan 11, 2017 at 8:29 PM, Josh Berkus wrote: > > For that reason, as of today, I am stepping down from the PostgreSQL > Core Team. Thank you for all your hard work and contributions to the project over the years Josh. Sometimes the work of PR and documentation (among others) gets sidelin

Re: [HACKERS] PostrgeSQL vs oracle doing 1 million sqrts am I doing it wrong?

2014-08-05 Thread Roberto Mello
On Tue, Aug 5, 2014 at 9:50 AM, Kevin Grittner wrote: > > Since that is outside the loop, the difference should be nominal; Apologies. I misread on my phone and though it was within the loop. > and in a quick test it was. On the other hand, reducing the > procedural code made a big difference.

Re: [HACKERS] PostrgeSQL vs oracle doing 1 million sqrts am I doing it wrong?

2014-08-05 Thread Roberto Mello
Em segunda-feira, 4 de agosto de 2014, testman1316 escreveu: > > SET SERVEROUTPUT ON > SET TIMING ON > > DECLARE > n NUMBER := 0; > BEGIN > FOR f IN 1..1000 > LOOP > n := SQRT (f); > END LOOP; > > In addition to the other suggestions that have been posted (using a procedural languag

Re: [HACKERS] pg_reorg in core?

2012-09-24 Thread Roberto Mello
an, pg_filedump, xlogdump, etc, etc...) as its sub-modules. Great idea! +1 Roberto Mello -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Oracle porting sample instr function

2012-07-06 Thread Roberto Mello
On Mon, Jul 2, 2012 at 8:51 PM, Greg Smith wrote: > > The INSTR implementation in the docs will instead search backwards from the > end of the string if you tell it to start at 0, same as if you gave it a > negative input. I think it's therefore possible to get the plpgsql version > to return

Re: [HACKERS] Re: [pgsql-advocacy] New Canadian nonprofit for trademark, postgresql.org domain, etc.

2011-05-09 Thread Roberto Mello
On Sat, May 7, 2011 at 2:01 PM, Peter Eisentraut wrote: > On fre, 2011-05-06 at 21:53 +0200, Cédric Villemain wrote: > > > > I think it might be better if the association don't need (or have ) > > activity other than 'technical' and to set up another nonprofit > > association for real activity. >

Re: [HACKERS] PostgreSQL Core Team

2011-04-28 Thread Roberto Mello
On Wed, Apr 27, 2011 at 2:48 PM, Dave Page wrote: > I'm pleased to announce that effective immediately, Magnus Hagander > will be joining the PostgreSQL Core Team. Well deserved. Congratulations! Roberto

Re: [HACKERS] Query Plan Columns

2010-11-07 Thread Roberto Mello
On Sat, Nov 6, 2010 at 6:24 PM, David E. Wheeler wrote: > > Would I be right that "Node Type" is the only column can be NOT NULL? > > Also, I'm thinking of making the "Actual Startup Time" and ""Actual Total > Time" columns into INTERVALs. The times are expressed in milliseconds, yes? > I'm wond

Re: [HACKERS] pg_rawdump

2010-10-19 Thread Roberto Mello
On Tue, Oct 19, 2010 at 6:13 PM, Stephen R. van den Berg wrote: > Greg Stark wrote: > >> But I'm not sure how useful. I mean, you can't really decipher >>everything properly without the data in the catalog -- and you have to >>premise this on the idea that you've lost everything in the catalog >>b

Re: [HACKERS] New PostgreSQL Committers

2009-12-07 Thread Roberto Mello
On Mon, Dec 7, 2009 at 6:49 AM, Dave Page wrote: > On behalf of the core team, I'm pleased to announce that the > PostgreSQL Project has expanded it's team of "committers", those > people who are able to make direct changes to the PostgreSQL source > code respository. As the project is extremely c

Re: [HACKERS] Internet is putting lot of competition fire & heat under Microsoft SQL Server

2001-05-15 Thread Roberto Mello
ther than that it has the same price tag more or less. I'm not defending the comparison/analogy, just saying that it makes sense to lay people who have heard of "Linux" when they are explained about PostgreSQL. -Roberto -- +| http://fslc.usu.edu USU

Re: [HACKERS] Converting PL/SQL to PL/PGSQL

2001-05-10 Thread Roberto Mello
he Procedure-definition is converted completely, the code-block > a little bit) Hmmm. *Very* interesting. Link? Source for this anywhere? We could probably use this at OpenACS. -Roberto -- +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto M

[HACKERS] Postmaster refuses to start

2001-05-04 Thread Roberto Mello
-Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer ---(end of broadcast)--- TIP 1

Re: [HACKERS] v7.1.1 branched and released on Tuesday ...

2001-05-02 Thread Roberto Mello
-Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer Junior, quit playing with your floppy! -

Re: [PATCHES] Re: [HACKERS] Support for %TYPE in CREATE FUNCTION

2001-04-29 Thread Roberto Mello
down the line is 7.2 (my guess is a few months away at least)? Is there a doc with what's planned for 7.2 somewhere? I know Jan Wieck mentioned improvements in the procedural languages. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Robert

Re: [HACKERS] Support for %TYPE in CREATE FUNCTION

2001-04-28 Thread Roberto Mello
ething I wish PostgreSQL had and I miss it everytime I write functions and remember PL/SQL. Thanks a lot Ian, I hope this one makes it in (hopefully for 7.1.1) -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer S

Re: [HACKERS] PL/SQL and null

2001-04-01 Thread Roberto Mello
3. Upgrade to 7.1. This has been fixed. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer *8 *8 *8

[HACKERS] [pgsql-hackers-owner+M6959@postgresql.org: Majordomo Delivery Error]

2001-03-31 Thread Roberto Mello
htmlhost.net -- Original message omitted -- - End forwarded message - -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer A semin

Re: [DOCS] Re: [HACKERS] Re: 7.1 docs

2001-03-25 Thread Roberto Mello
the function with the complete syntax and examples (usually two). http://oradoc.photo.net/ora81/DOC/server.815/a67779/function.htm#1028572 -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+ Roberto Mello - Computer Science, USU - http://www.br

Re: [HACKERS] Re: 7.1 docs

2001-03-23 Thread Roberto Mello
OpenACS project sometime next week. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer WHeRe is

Re: [HACKERS] Migration - Linux/pgSQL/PHP (type,version)

2001-03-21 Thread Roberto Mello
bian, try Progeny Debian (www.progeny.com). -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Web Develop

Re: [HACKERS] Call for platforms (linux 2.4.x ?)

2001-03-21 Thread Roberto Mello
U Free Software & GNU/Linux Club|--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please

Re: [HACKERS] Patch application

2001-03-21 Thread Roberto Mello
x. It will create HTML files from it. Example (using the Debian lists-archives package) can be seen at http://fslc.usu.edu/archives -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+ Roberto Mello - Computer Science, USU - http://www.brasi

Re: [HACKERS] Final Call: RC1 about to go out the door ...

2001-03-20 Thread Roberto Mello
On Tue, Mar 20, 2001 at 08:11:21PM +0100, Peter Eisentraut wrote: > > We need a supported platform list. Let's hear it. Linux 2.4.2 (Debian, Woody), glibc 2.2.2, gcc 2.95.3 (from CVS). -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--

[HACKERS] Contribute to the PL/pgSQL CookBook !!

2001-03-15 Thread Roberto Mello
t/postgres Oh, did I mention that you get your own "PostgreSQL Powered" button when you contribute a function/trigger? :) -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+ Roberto Mello - Computer Science, USU - http://www.br

[HACKERS] PL/SQL-to-PL/pgSQL-HOWTO + PL/pgSQL documentation

2001-02-24 Thread Roberto Mello
Hi, I think I finished the HOWTO that I've been writing far a couple days. The HTML version is at http://www.brasileiro.net/roberto/howto. The document expalins the basic differences from Oracle's PL/SQL to PoltgreSQL's PL/pgSQL and how to port applications to Postgres. It comes w