We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.
  1. Home
  2. ORM

Postgresql Metadata getDataTypes return wrong values

Hi, I'm trying to get colum types for some object (db is postgresql). I have in database column with Time type and getDataTypes for that column return value 2 so I think it's reserved for Varchar value. Can Time type can be added in some way?



77.7k

I think it's expected behaviour: there is only TYPE_DATETIME and TYPE_TIMESTAMP data type constant, both of which applies only to proper DateTime objects; TIme has no mapped type, since it has no applicable PHP primitive.



4.0k

So in this case it is possible to cache object tables column types but not using TYPE_? table but simply column type readed from DB?