Re: Auto Adjust Age

On 04/06/2011 08:53 AM, Carlos Mennens wrote:
> I've only been using PostgreSQL since Oct 2010 and it's my first
> experience with SQL or any ORDBMS. I've searched on the web and been
> creating my own database users, databases, tables from scratch which
> has been interesting to say the least but now I would like to know if
> this is possible in SQL or PostgreSQL since I can't find anything
> online that shows me how to do so. I've created a table called 'users'
> and I have it configured as follows:
>
> CREATE TABLE users
> (
>     id integer PRIMARY KEY UNIQUE NOT NULL, --ID
>     fname character varying(40) NOT NULL, --First name
>     lname character varying(40) NOT NULL, --Last name
>     email character varying NOT NULL, --email address
>     office integer NOT NULL, --Office number
>     dob date NOT NULL, --Date of birth
>     age integer NOT NULL --Age
> )
> ;
>
> Is there a way in SQL I can have the users 'age' be auto adjusted
> based on the 'id'&  'dob'? I would assume this is possible because if
> you have 100 employees, I doubt someone has time to sit and change
> everyone's age from 31>  32 on their birthday. Can someone please help
> explain how this works or what the SQL code would look like assuming
> that it's possible? I have no advanced far enough to see what triggers
> and views are so perhaps it's just my level with SQL in general.
>
> Thank you so much.
>
oops you do have dob.  Drop age and do the date manipulation "at runtime"