nothing ever works

From: gerardmatt(at)gmail(dot)com
To: pgsql-docs(at)postgresql(dot)org
Subject: nothing ever works
Date: 2017-06-21 08:39:40
Message-ID: 20170621083940.27874.47470@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/plpgsql-statements.html
Description:

Your documentation although it seems straight forward actually never
works.

The dynamic sql section gives example code, it does not execute.

It does not exec in a script block or as plain sql.

Please explain limitations or where the script can actually be executed.

As a beginner starting out in postgre you can never rely on the
documentation because the same thing happens, you copy the code and make
your modifications and you get syntax error.

The same problem exists with the Perform statement. It does not work as
advertised, you cannot execute it in a function or in a script block.

Clearly define the limitations of your language so that developers don't
waste their time.

Coming from ms sql quite frankly I would never recommend postgress. The
barrior to entry into actualy writing code is too great.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Pavel Stehule 2017-06-21 16:00:01 Re: nothing ever works
Previous Message Tom Lane 2017-06-19 16:01:42 Re: Missing RETURNS clause in function declaration