Restore empty string <-> int behaviour for 7.2

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Restore empty string <-> int behaviour for 7.2
Date: 2004-05-01 06:15:52
Message-ID: 200405010815.52892.mweilguni@sime.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

I've written a small patch that could be useful for people with old
applications, since it restores the original behaviour of silently treating
empty strings as 0 (at least for integers). It introduces a new bool GUC
variable "empty_equals_0" with default "off". With a simple "SET
empty_equals_0 to on" or via "ALTER DATABASE FOO ... SET empty_equals_0 to
on" the pre 7.3 behaviour can be restored again on a per database base.

I don't think such a patch is worthy for inclusion in postgresql, but as
external patch it's useful. What's the best place to submit such a patch?
gborg?

Thanks for the info!

Attachment Content-Type Size
patch-empty_equals_0 text/x-diff 2.0 KB

Browse pgsql-patches by date

  From Date Subject
Next Message Fabien COELHO 2004-05-01 14:21:21 new aggregate functions v1
Previous Message Neil Conway 2004-05-01 06:15:18 Re: ceiling() and power() (SQL2003)