From: | Jude DaShiell <jdashiel(at)panix(dot)com> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | pgsql novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: showing weekdays of dates |
Date: | 2014-08-29 19:18:35 |
Message-ID: | alpine.NEB.2.00.1408291515400.17131@panix3.panix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
this may help, originally I wanted the Day string to write out once a date
was entered followed by remaining fields. That will not work now given
current structure of the health table.
cut here.
create table health (
date date PRIMARY KEY,
Cystalic_Pressure int NOT NULL, check (Cystalic_Pressure > 0),
--- cystalic pressure
Dyastalic_Pressure int NOT NULL, check (Dyastalic_Pressure > 0),
--- dyastalic pressure
Pulse int NOT NULL, check (Pulse > 0),
--- pulse
Blood_Sugar int NOT NULL, check (Blood_Sugar > 0),
--- blood sugar
weekday int NOT NULL, check (weekday > -1), check (weekday < 7)
--- weekday number saturday=6
);
cut here.
#!/usr/bin/env bash
# file: uhealth.sh - update ahealth.sql
# last update: 2014-08-02
f1=`date -I`
echo -n "enter cystalic: "
read f2
echo -n "enter dyastalic: "
read f3
echo -n "enter pulse: "
read f4
echo -n "enter blood sugar: "
read f5
f6=`date '+%w'`
echo "insert into health values ('$f1',$f2,$f3,$f4,$f5,$f6);" >>ahealth.sql
On Fri, 29 Aug 2014, Merlin Moncure wrote:
> On Fri, Aug 29, 2014 at 12:39 PM, Jude DaShiell <jdashiel(at)panix(dot)com> wrote:
>> using sr pgdoc I searched for weekdays and though I found a few results I
>> couldn't parse from information provided how to get weekdays of dates to
>> populate a table in any fashion. When I do more in depth analysis of
>> accumulating data sets, some of the analysis I'd like to do would be for
>> each of the seven weekdays during a period of time. I ended up with a
>> script that does two date calls one for the iso date and the second for
>> weekday number and that script writes out the day's insert statement
>> correctly with the values it figures out and the values I supply. The whole
>> system I have now is for health monitoring blood pressure and blood sugar
>> numbers and that's how my doctor gets my numbers for checking progress. It
>> didn't take long to write, I like to improve it as I learn new things with
>> which I can improve it.
>
> Not completely following your question but perhaps to_char() function
> is what you need:
>
> ysanalysis=# select to_char(now(), 'Day');
> to_char
> ???????????
> Friday
>
> http://www.postgresql.org/docs/8.1/static/functions-formatting.html
>
> merlin
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | David G Johnston | 2014-08-30 00:34:32 | Re: Join three tables and specify criteria... I know this should be easy! |
Previous Message | Ken Benson | 2014-08-29 18:42:07 | Re: Join three tables and specify criteria... I know this should be easy! |