2 questions (array element retrieval and users connected)

From: Joep DeVocht <joep(at)masktools(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 2 questions (array element retrieval and users connected)
Date: 2003-05-01 20:15:51
Message-ID: 3EB18077.9F1E879D@masktools.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

I've searched the docs on it but don't seem to find an answer.

Relating to Postgres7.1, I have the following questions:

- I have a table with an array type column ( col decimal(25,10)[] ).
I tried retrieving individual elements using the C++ interface
GetValue function.
However, GetValue does not recognize for example col[1] as attribute
argument. It seems
that you need to retrieve the complete array string, and then pick it
apart to
store the values. Which is pretty awkward. My question is, is there a
more elaborate
function than GetValue that I can use. And if not, is there a function
to pick
apart the array values (it's easy to write myself, but since I'm sure
lots of people
run into this problem, there might already be one available that I
can't find)

- Is there a way to see who is connected to the postmaster?

Many thanx in advance,

Joep.

Browse pgsql-general by date

  From Date Subject
Next Message Ron St-Pierre 2003-05-01 20:28:52 TIMEZONE Problem
Previous Message Dmitri Bichko 2003-05-01 19:02:29 Re: deleting multiple rows