Re: [GENERAL] NULL values and string

2006-02-02 Thread Berend Tober
Richard Huxton wrote: Sergey Karin wrote: Are there any abilities to represent NULL values as string? Null isn't a real value. Try not to think of it as a value. That being said, and with due credit elsewhere (http://www.varlena.com/varlena/GeneralBits/84.php), what I do is CREATE OR R

Re: [GENERAL] NULL values and string

2006-02-02 Thread Richard Huxton
Sergey Karin wrote: Hi, List! I'm using PG8.1. Are there any abilities to represent NULL values as string? Null isn't a real value. Try not to think of it as a value. http://archives.postgresql.org/pgsql-sql/2003-01/msg00222.php num_value alias for $1; string_value := \'input val

Re: [GENERAL] NULL values and string

2006-02-02 Thread Tino Wildenhain
Sergey Karin schrieb: Hi, List! I'm using PG8.1. Are there any abilities to represent NULL values as string? I'm doing something like this: create function func(int4) returns varchar as' declare num_value alias for $1; string_value varchar; begin string_value := \'input value =

[GENERAL] NULL values and string

2006-02-02 Thread Sergey Karin
Hi, List! I'm using PG8.1. Are there any abilities to represent NULL values as string? I'm doing something like this: create function func(int4) returns varchar as' declare     num_value alias for $1;     string_value varchar; begin       string_value := \'input value = \' || num_value;    ret