Hi everyone,
I have a generel SQL question. What is the best way to
avoid inserting duplicate tuples in a table ?
using constraints ? Please refer me to a resource about
this topic.
Thank you for your time,
-Sheila
__
Get Your Private, Free Ema
Hi,
I've written an application for the web that asks users for their
id and password, checks the database and if they are legit
takes them to a page. Now I'm using the PHP_AUTH_USER variable
to identify the user and I need that information from one
file to another. How do I do that ? I tried sto
Hi everyone,
I'm trying to do a simple join query and I get an error message.
My tables are :
agency(agencyid serial, agency_name text, address text, ...)
groupleader(leaderid serial, agency_name text, phonenum text , ...)
The query :
SELECT agencyid FROM agency, groupleader WHERE
agency.
Hi ,
I think you are looking at the right place. PostgreSQL
can be installed on many platforms. For more information
have a look at the following sites:
Currently supported platforms:
http://www.postgresql.org/docs/postgres/ports.htm#AEN14551
Ports:
http://www.postgresql.org/docs/postgres/ports
Hi,
I'm new to data base design so please bare with me if my
question is so basic..
I'm designing a database, two of the tables are EMPLOYEES and
AGENCIES. I need an ID for each of them. I would also need to
have the agencyID in the EMPLOYEES table so that I can identify
which agency they belong
