Re: SQL Puzzle - Mailing list pgsql-general

From Jeff Post
Subject Re: SQL Puzzle
Date
Msg-id NGBBJHPOILLEGEKFHBEIEEMECPAA.postjeff@uwm.edu
Whole thread Raw
In response to SQL Puzzle  ("Ben-Nes Michael" <miki@canaan.co.il>)
List pgsql-general
Fill an array with "Absent".
Do a select that will pull the correct entries.
Do a loop and overwrite the appropriate array elements with "Worked" based
on the select results.
Then display the array.

Hopefully this helps,
  Jeff Post

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Ben-Nes Michael
Sent: Sunday, June 30, 2002 7:33 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] SQL Puzzle


Hi All

I have a table where all worker logon and out every day:

table columns: record_id, worker, log_time, status, description

If a worker was absent there will be no record for the current day.

Now, I want to query this table to get a list of all days in month and in an
aditional field i would like to put worked/abscent ( depends if he was or
was not )

Is it possible in SQL ?

I thought about fuction with 'for' from 1 to 30 then subselect to check if
worker worked on a current day but its a complicated solution.

Does any body have idea for easier method ?

I can do it easily in php but i want to do as maximum as I can on the db
itself.





---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)






pgsql-general by date:

Previous
From: "William N. Zanatta"
Date:
Subject: Re: known bugs in sequences ?
Next
From: Gunther Schadow
Date:
Subject: Re: recursing down a tree