Re: [firebird-support] Is Try_Cast in Firebird?
On 17-10-2016 12:10, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > No there isn't, although you could build something like that > yourself in > Firebird 3 with PSQL functions. > > Mark > -- > Mark Rotteveel > > Hi Mark, > > yes, PSQL function can be good but, you must specify type for input > parameters > i have created feature request for it > http://tracker.firebirdsql.org/browse/CORE-5378 Yes, you would need a function per type of input and output type, but on the other hand: if you need this a lot something is also wrong in the way your database is modeled. Mark -- Mark Rotteveel
Re: Re: [firebird-support] Is Try_Cast in Firebird?
W dniu 2016-10-17 10:17:33 użytkownik Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] napisał:
On 17-10-2016 10:10, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> i know
> Cast('XXX' AS Integer)
> but is there
> try_Cast('XXX' AS Integer)
> like in MSSQL?
> you know if something can not by converted then return null.
No there isn't, although you could build something like that yourself in
Firebird 3 with PSQL functions.
Mark
--
Mark Rotteveel
Hi Mark,
yes, PSQL function can be good but, you must specify type for input parameters
i have created feature request for it
http://tracker.firebirdsql.org/browse/CORE-5378
regards,
Karol Bieniaszewski
Re: [firebird-support] Is Try_Cast in Firebird?
On 17-10-2016 10:10, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> i know
> Cast('XXX' AS Integer)
> but is there
> try_Cast('XXX' AS Integer)
> like in MSSQL?
> you know if something can not by converted then return null.
No there isn't, although you could build something like that yourself in
Firebird 3 with PSQL functions.
Mark
--
Mark Rotteveel
[firebird-support] Is Try_Cast in Firebird?
Hi,
i know
Cast('XXX' AS Integer)
but is there
try_Cast('XXX' AS Integer)
like in MSSQL?
you know if something can not by converted then return null.
regards,
Karol Bieniaszewski
