agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Marius SERITAN <mseritan@nasta.ro>
To: postgres@postgres.Berkeley.EDU
Subject: iportal
Date: Tue, 4 Jul 95 11:28 EET DST
Message-ID: <m0sT3LE-000AyEC@liberty> (raw)


Hi,

My name is Marius SERITAN, I am the  sysadmin of the Pneumophtisiology
Institute  of   Bucharest,  Romania.  We    are a   non profit   healt
organization. I am  trying to use  Postgres as the database engine for
some of the programs I am writing for  the Institute. I  hope I am not
breaking any copyright or other regulations :-(

The hardware platform is a PC 486DX4 100 running Linux and release 4.0
of Postgres.

I am  desperately  needing a `group  by'  SQL like clause in  retrieve
statements or at least in aggregate functions as it was implemented in
the public release of ingres. Or maybe are there some other solutions?

At the moment I am doing all the processing in the C front end but it
is quite laborious and offsets most of the benefits of using
POSTQUEL. I am fetching data in an iportal as it is simpler to access
numerical values but strings get all messed up.  I am storing the
strings as `text' fields and they get printed allright in the
monitor. However when accessing some texts in the iportal using
PQgetvalue, the strings I obtain are not null terminated as C strings
usually do and the PQgetlength function returns a wrong length.  Is
this a bug or I am missusing some feature?


Marius SERITAN     mseritan%nasta.ro@pub.pub.ro
Sysadmin of the Pneumophtisiology Institute, Bucharest -- Romania

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: mseritan@nasta.ro
  Subject: Re: iportal
  In-Reply-To: <m0sT3LE-000AyEC@liberty>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox