I hereby claim:
- I am spreeker on github.
- I am spreeker (https://keybase.io/spreeker) on keybase.
- I have a public key ASDtbaWMuUZH5rn84GWhIZYVN_GVDQkK41RrGxNkZ3yfXgo
To claim this, I am signing this object:
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| drop function postcode_to_int; | |
| -- create a function turning a postal code into a number. | |
| CREATE OR REPLACE FUNCTION postcode_to_int(pc text) | |
| RETURNS int AS $$ | |
| DECLARE | |
| num_part int; | |
| letters text; | |
| letter_1 int; | |
| letter_2 int; |