Thread: PostgreSQL catalog

PostgreSQL catalog

From
f2160528@est.fib.upc.es
Date:
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.

Re: PostgreSQL catalog

From
"Thalis A. Kalfigopoulos"
Date:
On Fri, 15 Feb 2002 f2160528@est.fib.upc.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
andits 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
>