PostgreSQL catalog

Started by Nonameabout 24 years ago2 messagesgeneral
Jump to latest
#1Noname
f2160528@est.fib.upc.es

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.

#2Thalis A. Kalfigopoulos
thalis@cs.pitt.edu
In reply to: Noname (#1)
Re: PostgreSQL catalog

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 and its preprocessor at:
http://www.postgresql.org/idocs/index.php?ecpg.html

cheers,
thalis

Show quoted text

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html