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

[Ansgar Brauner]

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