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