pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Brian C. Doyle <bcdoyle@mindspring.com>
To: pgsql-sql@postgresql.org
Subject: Re: Multiple Index's
Date: Thu, 21 Sep 2000 13:30:02 -0400
Message-ID: <5.0.0.19.2.20000921132629.032fdb60@pop> (raw)
In-Reply-To: <009401c023f1$5561b0d0$0200000a@doot>
References: <5.0.0.19.2.20000921130926.02c2ad30@pop>

See if this help

the table has

userid | date | helped_customers

An employ will enter in their userid, the date and how many customer they 
helped that day.

What I want to do is prevent the employees from enter the data more than 
once a day

At 10:28 AM 9/21/00 -0700, Mitch Vincent wrote:
> > Hello all,
> >
> > How would I prevent a user from submitting information to a table once
>they
> > have already done so for that day.
>
>The best you could probably do is to go back and delete undesired recoords
>at the end of the day because if it is as you said, they've already put the
>information into the database.
>
> > I would need them to be able
> > information on future dates as well as have information in the table from
> > past dates from that user.
>
>Not positive what you mean here but just use a date (or timestamp) column in
>the table to indicate when the record was added.
>
> > I am looking for something like insert user_id, date, info where user_id
> > and date are not the same... does that make sense?
>
>Nope, it doesn't --  at least to me :-)
>
>How about some table structures and some more information,  I'm just not
>exactly sure what you'd like to do..
>
>-Mitch




view thread (5+ messages)

Message-ID: <5.0.0.19.2.20000921132629.032fdb60@pop>
Permalink:  ../5.0.0.19.2.20000921132629.032fdb60@pop/
Also on:    postgresql.org/message-id/5.0.0.19.2.20000921132629.032fdb60@pop

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: bcdoyle@mindspring.com
  Subject: Re: Multiple Index's
  In-Reply-To: <5.0.0.19.2.20000921132629.032fdb60@pop>
  References: <5.0.0.19.2.20000921130926.02c2ad30@pop> <5.0.0.19.2.20000921132629.032fdb60@pop>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox