Re: PostgreSQL catalog

From: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
To: f2160528(at)est(dot)fib(dot)upc(dot)es
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL catalog
Date: 2002-02-15 21:27:17
Message-ID: Pine.LNX.4.21.0202151559120.11314-100000@aluminum.cs.pitt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 15 Feb 2002 f2160528(at)est(dot)fib(dot)upc(dot)es wrote:

> Hi everybody,
>
> I need to access to PostgreSQL catalog in order
> to obtain the maximum and the minimum values of
> a relation.
>
> Does anyone know how to do this from a C
> program???
>
> Thanks in advance.
>
> David.

I'ts sort of vague what you mean by "max/min value of a relation". If you mean the "max/min value of an attribute of a relation", then no need to access the catalog. It's pure SQL, and to do it through a C program, read about embeded SQL and its preprocessor at:
http://www.postgresql.org/idocs/index.php?ecpg.html

cheers,
thalis

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wolfe 2002-02-15 21:39:52 Re: Question: Who's Using Postgres
Previous Message Nick Fankhauser 2002-02-15 21:18:09 Re: Question: Who's Using Postgres