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.
Change "age" to birthyear and do date arithmetic in your reporting.
(Better yet get, birthdate to start with.)
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
