PostgreSQL Array & Java

From: Frederik (aerts_frederik_at_hotmail.com)
Date: 05/31/04

  • Next message: Roedy Green: "Re: PostgreSQL Array & Java" 
    Date: 30 May 2004 15:49:42 -0700

    Hi all,

    I have a table that contains an array as one of its fields. When I'm
    returning some results from the database (including that particular
    field), the array is returned as a String. The thing is: I need an
    array of Strings, not just one String.

    My question: can PostgreSQL return an array of Strings or can it only
    return a string. If it can only return one String, what would be the
    best way to parse it in order to get the separate elements of the
    array?

    I hope I'm missing something simple here :o

    Thans for your time,
    Frederik

  • Next message: Roedy Green: "Re: PostgreSQL Array & Java"

    Relevant Pages

    • Re: What could be the problem with this INSERT with ADO parameters?
      ... The only way I have found sofar is to enclose the string in single ... written to the database. ... But that gives the same problem, it actually crashes Excel. ... how do I handle a string with comma's in the parameter array? ...
      (microsoft.public.data.ado)
    • Re: What could be the problem with this INSERT with ADO parameters?
      ... The only way I have found sofar is to enclose the string in single ... written to the database. ... But that gives the same problem, it actually crashes Excel. ... how do I handle a string with comma's in the parameter array? ...
      (microsoft.public.data.ado)
    • Re: passing a string to a dll
      ... Joe, I really appreciate you taking the time to demonstrate this. ... sure how I would implement indexing it for random alphanumeric codes. ... I might handle the array. ... I actually have been wondering if I could use a second string ...
      (microsoft.public.vc.mfc)
    • Re: passing a string to a dll
      ... I might handle the array. ... I actually have been wondering if I could use a second string ... look at insertion cost, organization cost, and search cost. ...
      (microsoft.public.vc.mfc)
    • Re: Array Type Mismatch
      ... Dim resultAs String ... I am still somewhat confused as to why nothing is stored in the array. ... Public Function TextBoxGetLine(....arguments... ...
      (microsoft.public.access.formscoding)