"Gerwin Philippo" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I have function that appends 2 columns, like
> "new.field1 = new.field2||new.field3",
> but when field 3 is null, then the entire outcome is null, while I
> expected just field2, since when I append nothing to field2,
You are welcome. Only if all problems were that simple ;-)...
"Gerwin Philippo" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> THX! didn't know that one yet :)
>
> nobody wrote:
> > "Gerwin Philippo" <[EMAIL PROTECTED]> wrote
I have found it in documentation, it is single quote. But it does not
explain why
SELECT '1/11/2003' AS "InvoiceDate";
returns "unknown" data type instead of "date".
"nobody" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
&g
What is correct character to quote date values in SELECT. Is is single
quote?
When I do:
SELECT '1/11/2003' AS "InvoiceDate";
the returned value is of unknown type (not a date).
Then I tried:
SELECT 1/11/2003 AS "InvoiceDate";
and the InvoiceDate was set to zero (I guess the engine divided th
Thanks, I learnt to use:
SELECT CAST('1/11/2003' AS DATE) AS invoice_number;
and it does what I would expect ;-).
"Stephan Szabo" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> On Fri, 21 Nov 2003, Gaetano Mendola wrote:
>
> &g
