Wish: remove ancient constructs from Postgres

From: "Andrus Moor" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Wish: remove ancient constructs from Postgres
Date: 2006-02-26 08:36:23
Message-ID: dtrpbh$2v60$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It is difficult to write standard-compliant code in Postgres.
There are a lot of constructs which have SQL equivalents but are still used
widely, even in samples in docs!

For example, there are suggestions using

now()::CHAR!=foo

while the correct way is

CAST(CURRENT_DATE AS CHAR)<>foo

now() function, :: and != operators should be removed from language.

I like the Python logic: there is one way
Postgres uses C logic: there are multiple ways.

Bruce seems to attempt start this process trying implement
escape_string_warning in postgresql.conf . However, this is only very minor
step. Please clean Postgres.

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2006-02-26 08:37:38 Re: Is the pg_locks been used?
Previous Message Joshua D. Drake 2006-02-26 03:52:14 Re: postgresql documentation