1. Forum
  2. Usenet
  3. COMP.DATABASES.POSTGRESQL

  • all types returned in result are strings

    From Majid Lotfi@21:1/5 to All on Mon Apr 9 10:11:46 2018
    Hi, I am using postgres from ruby using pg gem, I did a select * from table, but all integer, smallint, timestamp types are returned as strings.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Robert Klemme@21:1/5 to Majid Lotfi on Mon Apr 9 23:17:56 2018
    On 09.04.2018 19:11, Majid Lotfi wrote:
    Hi, I am using postgres from ruby using pg gem, I did a select * from
    table, but all integer, smallint, timestamp types are returned as
    strings.

    Please show the code, maybe with the relevant part of the schema definition.

    Kind regards

    robert

    --
    remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)