Re: [GENERAL] Syntax Error for "boolean('value')" Type Casting

2011-05-22 Thread David Johnston
On May 22, 2011, at 6:22, Alban Hertroys wrote: > On 21 May 2011, at 21:17, David Johnston wrote: > >> SELECT boolean('true') >> SQL Error: ERROR: syntax error at or near "(" LINE 1: SELECT boolean('true') ^ >> >> The following work as expected: >> >> SEL

Re: [GENERAL] Syntax Error for "boolean('value')" Type Casting

2011-05-22 Thread Alban Hertroys
On 21 May 2011, at 21:17, David Johnston wrote: > SELECT boolean('true') > >>> SQL Error: ERROR: syntax error at or near "(" >>> LINE 1: SELECT boolean('true') >>> ^ > > The following work as expected: > > SELECT bool('true') (...) > While I'm here.is there any downside t

[GENERAL] Syntax Error for "boolean('value')" Type Casting

2011-05-21 Thread David Johnston
PostgreSQL 9.0.3, compiled by Visual C++ build 1500, 64-bit The following intuitively valid statement fails: SELECT boolean('true') >>SQL Error: ERROR: syntax error at or near "(" >>LINE 1: SELECT boolean('true') >> ^ The following work as expected: SELEC