| 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: | Whole Thread | Raw Message | 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) |