[Fwd: Re: converting number to string in query] - Mailing list pgsql-novice

From Andreas Wenk
Subject [Fwd: Re: converting number to string in query]
Date
Msg-id 4A54565E.1090803@netzmeister-st-pauli.de
Whole thread Raw
List pgsql-novice
Michael Wood schrieb:
> Hi
>
> 2009/7/7 Andreas Wenk <a.wenk@netzmeister-st-pauli.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




pgsql-novice by date:

Previous
From: Michael Gould
Date:
Subject: Table Partitioning
Next
From: Ms swati chande
Date:
Subject: Password?