Michael Wood schrieb:
> Hi
>
> 2009/7/7 Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de>:
> [...]
>> You have to typecast the integer 9:
>>
>> postgres=# SELECT id FROM test WHERE string = 9::text;
>> id
>> ----
>> (0 rows)
> [...]
>
> My understanding is that 9::text is PostgreSQL specific, and that
> cast(9 as text) would be more portable. Is this correct?
>
> See: http://www.postgresql.org/docs/current/static/sql-expressions.html#SQL-SYNTAX-TYPE-CASTS
>
yes that's correct - to be honest - I don't know if this short syntax is maybe also
supported in other DBMS but I don't think so ...
Cheers
Andy