Re: [HACKERS] Retiring from the Core Team

[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
sidelined and not given the appropriate importance.

I wish you all the best in your current and future endeavors, and hope our
paths will cross again sometime.

Roberto

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

[Roberto Mello]

Em segunda-feira, 4 de agosto de 2014, testman1316 danilo.rami...@hmhco.com
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 language more suitable to mathematical ops, etc) I noticed that
you are using a RAISE in the PostgreSQL version that you are not in Oracle.

I am curious as to what the difference is if you use the RAISE in both or
neither cases.

Roberto

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

[Roberto Mello]

On Tue, Aug 5, 2014 at 9:50 AM, Kevin Grittner kgri...@ymail.com 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.

snip

 test=# DO LANGUAGE plpgsql $$ DECLARE n real;
 BEGIN
   PERFORM SQRT(f) FROM generate_series(1, 1000) x(f);
 END $$;
 DO
 Time: 3916.815 ms

That is a big difference. Are you porting a lot of code from PL/SQL,
and therefore evaluating the performance difference of running this
code? Or is this just a general test where you wish to assess the
performance difference?

PL/pgSQL could definitely use some loving, as far as optimization
goes, but my feeling is that it hasn't happened because there are
other suitable backends that give the necessary flexibility for the
different use cases.

Roberto


-- 
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] pg_reorg in core?

[Roberto Mello]

On Sat, Sep 22, 2012 at 3:25 AM, Satoshi Nagayasu sn...@uptime.jp wrote:

 To solve this problem, I would like to have some umbrella project.
 It would be called pg dba utils, or something like this.
 This umbrella project may contain several third-party tools (pg_reorg,
 pg_rman, 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

[Roberto Mello]

On Mon, Jul 2, 2012 at 8:51 PM, Greg Smith g...@2ndquadrant.com wrote:


snip

 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 a value in cases Oracle would instead return 0.  Seems like a
 straightforward thing to confirm and change the sample to do differently;
 just have to add an explicit test for a 0 value of beg_index.

I wrote that sample eons ago with the plpgsql-porting doc. I probably
overlooked the 0 behavior. Thanks for reporting Greg, and thanks Albe
for providing a patch.

Roberto

-- 
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] Re: [pgsql-advocacy] New Canadian nonprofit for trademark, postgresql.org domain, etc.

[Roberto Mello]

On Sat, May 7, 2011 at 2:01 PM, Peter Eisentraut pete...@gmx.net 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.

 If instead you limit yourselves to holding and maintaining the mentioned
 assets, the board meets once a year to approve last year's minutes, file
 the paperwork, and go home, you can't do much wrong.


I quite agree on this.

The NPO new is excellent, btw.

Roberto

Re: [HACKERS] PostgreSQL Core Team

[Roberto Mello]

On Wed, Apr 27, 2011 at 2:48 PM, Dave Page dp...@postgresql.org 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

[Roberto Mello]

On Sat, Nov 6, 2010 at 6:24 PM, David E. Wheeler da...@kineticode.com 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 wondering if INTERVAL would be more convenient for querying…

Yes, but I am wondering whether you should just stick to what would
come out of a normal explain, for consistency sake. Maybe provide
another function, or parameter that would cast the results to
intervals?

Not sure.

Roberto

-- 
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] pg_rawdump

[Roberto Mello]

On Tue, Oct 19, 2010 at 6:13 PM, Stephen R. van den Berg s...@cuci.nl 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
but not the data in other tables. Which seems like a narrow use case.

 It happens, more often than you'd think.  My client had it, I've
 seen numerous google hits which show the same.

It happened to us recently when a customer had disk issues, and we
were able to get the table files back through forensics, but the
control files were not in good shape, and the cluster wouldn't start.

A tool like Stephen is proposing would most likely have helped us
recover at least some or most of the data, I would hope.

Roberto

-- 
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] New PostgreSQL Committers

[Roberto Mello]

On Mon, Dec 7, 2009 at 6:49 AM, Dave Page dp...@pgadmin.org 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 conservative about any
 changes made to the source code to minimise the risk of introducing
 any bugs, commit access is only given to contributors who have
 consistently shown they work to a very high standard and have shown
 commitment to the project.

+1 on the congratulations, and thank you for all your work.

Roberto

-- 
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] Internet is putting lot of competition fire heat under Microsoft SQL Server

[Roberto Mello]

On Tue, May 15, 2001 at 07:19:01AM -0400, D'Arcy J.M. Cain wrote:

  Everybody is asking What is the equivalent of Linux in SQL databases
  ??
  The answer is PostgreSQL RDBMS server.
 
 Oh please.  Can we stop trying to tie everything to the current front
 runner.  I mean, PostgreSQL uses the BSD style license, development

It uses _the_ BSD license. 

 is done under the BSD (cathedral) model and hey, it was invented at
 Berkeley in the first place.  How is it the equivalent of Linux
 other 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 Free Software  GNU/Linux Club |--+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
   http://www.sdl.usu.edu - Space Dynamics Lab, Developer
Bad command or file name. Go sit in corner.

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

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

[Roberto Mello]

On Thu, May 10, 2001 at 03:33:27PM +0200, Klaus Reger wrote:
 Hi all!
 
 I have to convert functions and procedures from Oracle to PostgreSQL. I 
 looked at all the stuff of the Pg-Homepage and I ask me if there are any 
 tools, that support the conversion. 

That help you in the conversion, no.
Have you looked at the Porting From Oracle PL/SQL chapter of the
PostgreSQL Programmer's Guide? I am expanding that guide to include more
things, like queries. The goas is for it to become a Porting From
Oracle guide.
 
 Writing PS/PGSQL tools seems to be a bit hard, because of the existing 
 tool-infrastructure on linux. Are there are tools I have overseen?

Heh? What do you mean by this? There are zillions of editors, both
console and graphical, where you can do this.
I have found pgaccess to be vey useful in testing. In the OpenACS
project (www.openacs.org) we port thousands of lines of Oracle code to
PostgreSQL, mostly using vim or Emacs.
For testing, I use pgaccess because it lets me drop/recreate a
function easily, plus it escapes quotes. One thing I don't like about it
is that it's hard to keep things indented.

 - A WWWdb-Application for editing and testing of SQL-Procedures over a
   WEB-frontend

Cool. Anywhere we can see this in action?

 - A perl-script, that does basic conversions between PL/SQL - XML -
   PL/PGSQL (The 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 Mello - Computer Science, USU - http://www.brasileiro.net 
   http://www.sdl.usu.edu - Space Dynamics Lab, Developer
(D)inner not ready:  (A)bort (R)etry (P)izza

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[HACKERS] Postmaster refuses to start

[Roberto Mello]

My postmaster is refusing to start. I don't know what's wrong. If
anyone has pointers/tips/whatever, please tell me. 
One of my backup scripts was wrong so I don't have current backups
(that's what you get for trusting other people to do your backups). Any
way to recover my databases? 
The oddities started yesterday. Everytime I'd call a PL/pgSQL
function, the backend would die. The function was working perfectly up to
that point so I know there's nothing wrong with it.
I am running PG 7.1 from the Debian packages.

Here's what my log says:

[tons of these]
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
Server process (pid 3599) exited with status 11 at Thu May  3 10:32:47 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 10:32:55 2001
Reinitializing shared memory and semaphores
Server process (pid 3616) exited with status 11 at Thu May  3 10:35:21 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 10:35:21 2001
Reinitializing shared memory and semaphores
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
Server process (pid 5115) exited with status 11 at Thu May  3 16:03:09 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:03:12 2001 
Reinitializing shared memory and semaphores
Server process (pid 5118) exited with status 11 at Thu May  3 16:03:42 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:03:42 2001
Reinitializing shared memory and semaphores
Server process (pid 5122) exited with status 11 at Thu May  3 16:04:00 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:04:00 2001
Reinitializing shared memory and semaphores
Server process (pid 5158) exited with status 11 at Thu May  3 16:08:43 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:08:45 2001 
Reinitializing shared memory and semaphores
Server process (pid 5176) exited with status 11 at Thu May  3 16:15:32 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:15:33 2001
Reinitializing shared memory and semaphores
The Data Base System is starting up
The Data Base System is starting up
pq_recvbuf: unexpected EOF on client connection
Smart Shutdown request at Thu May  3 16:17:59 2001
Server process (pid 5271) exited with status 11 at Thu May  3 16:21:35 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:21:36 2001
Reinitializing shared memory and semaphores
Server process (pid 5288) exited with status 11 at Thu May  3 16:26:47 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:26:49 2001
Reinitializing shared memory and semaphores
Server process (pid 5293) exited with status 11 at Thu May  3 16:28:32 2001
Terminating any active server processes...
Server processes were terminated at Thu May  3 16:28:32 2001 
Reinitializing shared memory and semaphores
The Data Base System is starting up
Server process (pid 7780) exited with status 512 at Fri May  4 04:06:34 2001
Terminating any active server processes...
Server processes were terminated at Fri May  4 04:06:34 2001
Reinitializing shared memory and semaphores
/usr/lib/postgresql/bin/postmaster: Startup proc 7781 exited with status 512 - abort
/usr/lib/postgresql/bin/postmaster: Startup proc 9347 exited with status 512 - abort
/usr/lib/postgresql/bin/postmaster: Startup proc 9364 exited with status 512 - abort
/usr/lib/postgresql/bin/postmaster: Startup proc 9380 exited with status 512 - abort

These last lines are me trying to restart the postmaster via pg_ctl
with debugging set to 5.

Any help is very much appreciated.

-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: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

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

[Roberto Mello]

On Mon, Apr 30, 2001 at 07:12:16PM -0400, Tom Lane wrote:
 
  There will surely be a 7.1.2.  I vote against waiting for it.
 
 Possibly, but one hopes 7.1.2 will be a few months away ...

Is there a chance for the %TYPE patch for PL/pgSQL to make it into
7.1.2?

-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!

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

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

[Roberto Mello]

On Sat, Apr 28, 2001 at 06:45:39PM -0400, Bruce Momjian wrote:
 
 Sorry, only in 7.2.  No new features in minor releases unless they are
 very safe.

So how was that patch not safe?
It sure would make porting Oracle apps to PostgreSQL _much_ easier.
How far 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 |--+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
   http://www.sdl.usu.edu - Space Dynamics Lab, Developer
Keyboard not connected, press F1 to continue.

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

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

[Roberto Mello]

On Fri, Apr 27, 2001 at 08:45:25PM -0700, Ian Lance Taylor wrote:
 This patch adds support for %TYPE in CREATE FUNCTION argument and
 return types.
 
 %TYPE is already supported by PL/pgSQL when declaring variables.
 However, that does not help with the argument and return types in
 CREATE FUNCTION.
 
 Using %TYPE makes it easier to write a function which is independent
 of the definition of a table.  That is, minor changes to the types
 used in the table may not require changes to the function.

Wow! This would be _very_ useful! It's something 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 Science, USU - http://www.brasileiro.net 
   http://www.sdl.usu.edu - Space Dynamics Lab, Developer
-°*'. (Explosive Tagline)

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

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

[Roberto Mello]

I think somebody has the "owner" address forwarding to the list.
Really annoying. Would somebody please stop that?

Thanks,

-Roberto

- Forwarded message from [EMAIL PROTECTED] -

From: [EMAIL PROTECTED]
Subject: Majordomo Delivery Error
To: [EMAIL PROTECTED]
X-VMS-To: IN%"[EMAIL PROTECTED]"

This message was created automatically by mail delivery software.
A Majordomo message could not be delivered to the following addresses:

  [EMAIL PROTECTED]:
450 4.7.1 [EMAIL PROTECTED]... Can not check MX records for recipient host 
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 seminar on Time Travel will be held two weeks ago

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

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

[Roberto Mello]

On Sat, Mar 24, 2001 at 11:32:02AM -0500, Tom Lane wrote:
 
 A "page per function" approach is clearly overkill for the vast majority
 of our functions.  I think that's not unrelated to the fact that no one's
 ever bothered to prepare such documentation ;-)

Agreed.
 
 On the other hand, the existing layout of the User's Guide encourages a
 "line per function" approach, which is insufficient for at least some
 functions.  We've worked around that by adding paragraphs below the main
 table on each page, but that seems a little awkward in many cases.

Again I agree. The functions docs are insufficient for most functions
I would say.
I like the way the Oracle functions are documented, except for the
fact that they have one huge page for all functions, which is hard on
those on slow connections reading docs online. 
They have functions in tables grouped per functionality (e.g. character
functions that returning character values, character functions returning
number values) and with each function name (which is all that is in the
table) is linked to a larger explanation of 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.brasileiro.net 
  http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer
If it wasn't for C, we would be using BASI, PASAL and OBOL!

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Patch application

[Roberto Mello]

On Wed, Mar 21, 2001 at 10:54:46AM -0500, Bruce Momjian wrote:
 
 Can someone suggest a nice web frontend CGI script to a mbox file, one
 that shows sender/subject/date, etc?  I don't need to search or modify
 the messages, just display them.

Run mhonarc on the mbox. 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.brasileiro.net 
  http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer
ONLINE? Hit ALT+H for a quick I.Q. Test!

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

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

[Roberto Mello]

On Thu, Mar 22, 2001 at 12:31:03PM +1200, Franck Martin wrote:
 I see nobody did a test of 7.1 on Linux 2.4.x ?
 
 Would be nice to certify it is running on kernel 2.4.x as they claim this
 is entreprise strength kernel...

I've been running the 7.1 betas on 2.4 for weeks without any problems.
I replied to the "call for platforms" e-mail, but it looks like it got
lost in the avalanche.
I'll run the regression tests with the latest CVS snapshot and submit
a report to the list.

-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

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

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

[Roberto Mello]

On Thu, Mar 22, 2001 at 11:33:16AM +1030, Steven Vajdic wrote:
 
 1. I've been running RedHat6.2 and its pgSQL 6.5xx, PHP3.0 counterparts

You should definitely upgrade to PG 7.1.

 2. I am thinking about Debian (my preferred option - good/easy for
 "automatic" WEB upgrades) or
 Mandrake or Suse/professional (best ranking in some PC magazines).
 Strange: The rankings (No 1 Mandrake, No 2 Suse) did not test Debian -
 accidentally or deliberately?

Don't know which "ranking" you are referring to. These are good
distributions. Red Hat is also good, but IMHO some things in 7.0 just
shouldn't have shipped the way they were. Supposedly 7.1 will be much
better.
Debian is excellent. I've been running for quite some time and am very
happy with it. If you are looking for an easy install of Debian, 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 Developer
Dammit Jim, I'm a doctor, not a ... Windows 95 Beta Tester

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

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

[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|--+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
  http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

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

[Roberto Mello]

I have started the "PL/pgSQL CookBook" project. The goal is to
create a cookbook of PL/pgSQL functions that will be catalogued and made
available for others to use and learn from.
Come to http://www.brasileiro.net/postgres and contribute your own 
PL/pgSQL (or PL/Tcl, PL/Perl) function or trigger! This will help many
Postgres users, both novice and experienced, to use its procedural
languages.
The CookBook has several sections, and you can add your own. No login
is required, just come and contribute.

Once again http://www.brasileiro.net/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.brasileiro.net 
  http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer
Tetris tagline: @@  o@o    @oo  oo@  

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

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

[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
with several examples and the code for a port of Oracle's instr functions.
I wrote it in standard DocBook and would be glad to give it to the PG
team if there's interest in including its whole or part in the
documentation. Just let me know who should I send it to.

Another issue is that I'd like to revamp the PL/pgSQL main docs. The
way it is right is hard to find what you want because everything is buried
under the "Description" page. Plus the documentation could use _a lot_
more examples, especially of things that people use often, like "FOR ROW",
loops, etc.
Would that be something the PG team would be interested in?

Thoughts? 

-Roberto

P.S: Thanks so much for PG. I love it!

-- 
Computer ScienceUtah State University
Space Dynamics Laboratory   Web Developer
USU Free Software  GNU/Linux Club  http://fslc.usu.edu
My web site: http://www.brasileiro.net