Re: [GENERAL] Type cast text to int4

2007-09-07 Thread Martijn van Oosterhout
On Fri, Sep 07, 2007 at 01:40:57PM +0200, M. van Egmond wrote: > Could you please give me the correct syntax to create a basetype using > pl/pgsql functions instead of external functions? > Or is this impossible? It's not possible. You need to be able to deal with raw C strings and internal datat

Re: [GENERAL] Type cast text to int4

2007-09-07 Thread M. van Egmond
Could you please give me the correct syntax to create a basetype using pl/pgsql functions instead of external functions? Or is this impossible? Thanks. Martijn van Oosterhout schreef: On Fri, Sep 07, 2007 at 11:36:23AM +0200, M. van Egmond wrote: Hello everybody, Im having troubles overri

Re: [GENERAL] Type cast text to int4

2007-09-07 Thread Martijn van Oosterhout
On Fri, Sep 07, 2007 at 11:36:23AM +0200, M. van Egmond wrote: > Hello everybody, > > Im having troubles overriding postgresql's default behaviour of throwing > an error while trying to cast an empty string to int4. I would like to > cast empty strings to a null integer value. I've tried this by c

[GENERAL] Type cast text to int4

2007-09-07 Thread M. van Egmond
Hello everybody, Im having troubles overriding postgresql's default behaviour of throwing an error while trying to cast an empty string to int4. I would like to cast empty strings to a null integer value. I've tried this by creating my own domain: CREATE DOMAIN my_int AS integer; -- Then create

[GENERAL] Type cast text to int4

2007-09-07 Thread M. van Egmond
Hello everybody, Im having troubles overriding postgresql's default behaviour of throwing an error while trying to cast an empty string to int4. I would like to cast empty strings to a null integer value. I've tried this by creating my own domain: CREATE DOMAIN my_int AS integer; -- Then cr