[TYPO3-english] t3blog on postgres (continuation)

Xavier Perseguers xavier at typo3.org
Wed Jun 22 23:59:34 CEST 2011


Hi,

> But I have another a question to you, Xavier. Is it possible to convert
> column value inside a query? Is there any portable syntax? Will Postgres
> syntax (tx_t3blog_post.author::bigint) be correctly parsed by DBAL?

No, you will very likely hit the limit of the TYPO3 SQL parser which 
only understand a small subset of SQL syntax. Thus do not count on 
CONVERT() or CAST() calls if you want DBAL support.

HTH

-- 
Xavier Perseguers
Release Manager TYPO3 4.6

TYPO3 .... inspiring people to share!
Get involved: http://typo3.org



More information about the TYPO3-english mailing list