Michael Wood schrieb:
> 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;
>> (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 ...
pgsql-novice by date
|Next:||From: Ms swati chande||Date: 2009-07-08 09:21:06|
|Previous:||From: Michael Gould||Date: 2009-07-07 18:00:55|
|Subject: Table Partitioning|