[TYPO3-dev] Using Postgres in an Extension and use pure SQL

[ries van Twisk]

On Jan 28, 2009, at 9:27 AM, Ansgar Brauner wrote:

> Hi there,
>
> i already managed it to integrate Postgres and TYPO3 to use Postgres
> Data in my extension.
>
> Now the question: is there any way to create the complete Postgres SQL
> Query? In my special case i'd like to Cast types in my query. For  
> example:
>
> SELECT DISTINCT TO_CHAR ( date, 'DD.MM.YYYY' ) AS date_only FROM  
> tx_mytable;
>
> Would be nice if there is any solution (maybe with pure Adodb) to  
> solve
> this.
>
>
> thanks in advance
>
> regards
>
> Ansgar

Can you explain a bit better what you are trying to do?

Ries