Skip site navigation (1) Skip section navigation (2)


From: Margarita Barvinok <brita(at)math(dot)lsa(dot)umich(dot)edu>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: [INTERFACES]- SELECT statement
Date: 1999-02-25 14:26:50
Message-ID: (view raw or whole thread)
Lists: pgsql-interfaces

I have two questions.
 How can I realize this query in C-Embedded SQL?

SELECT MAX (score)
  FROM report
  WHERE uname = 'xxxxxxx'
  AND exam_id IN
      ( SELECT exam_id 
        FROM exam
        WHERE name = 'yyyy'
I used DECLARE CURSOR and FETCH for second SELECT statement.
But I don't know how to use WHERE ... IN clause.

I need to create weekly report. I would like to ask users to enter just
one date (for example, Monday of the week).
How can I select information from database for a whole week?

Thank you



pgsql-interfaces by date

Next:From: Tom LaneDate: 1999-02-25 15:01:53
Subject: Re: [INTERFACES] What's that query limit again?
Previous:From: Mark HimsleyDate: 1999-02-25 10:05:34
Subject: Re: [INTERFACES] What's that query limit again?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group