Re: PostgreSQL catalog

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
>