Re: [SQL] empty string casting to typed value

2004-06-07 Thread Stephan Szabo
On Mon, 7 Jun 2004, sad wrote: > It is clear that '' is a bad integer or timestamp representation > > but during the user input NULLs are usually represented with empty strings > sometimes bunch of 'if empty' instructions grows huge > (and in case of casting to timestamp apostrophes make sense)

Re: [SQL] empty string casting to typed value

2004-06-07 Thread Bruno Wolff III
On Mon, Jun 07, 2004 at 10:37:44 +0400, sad <[EMAIL PROTECTED]> wrote: > Hello > > It is clear that '' is a bad integer or timestamp representation > > but during the user input NULLs are usually represented with empty strings > sometimes bunch of 'if empty' instructions grows huge > (and in c

[SQL] empty string casting to typed value

2004-06-07 Thread sad
Hello It is clear that '' is a bad integer or timestamp representation but during the user input NULLs are usually represented with empty strings sometimes bunch of 'if empty' instructions grows huge (and in case of casting to timestamp apostrophes make sense) Why you prohibit casting ''::int