Hey Sherwin,
You da man!
Your statement worked great, I just had to put parentheses around key:
i.e.
DISTINCT ON (key)
Thank you very much.
Chris.
>>> "pgsql-admin" <[EMAIL PROTECTED]> 10/29/00 09:42PM >>>
try
INSERT INTO table2
SELECT DISTINCT ON key key, name, field1, field2
FROM tabl
try
INSERT INTO table2
SELECT DISTINCT ON key key, name, field1, field2
FROM table1;
sherwin
[EMAIL PROTECTED] writes:
>Hello,
>
>I'm sure I'll be flagged as a moron for asking this question, so be it.
>
>I have some tables of info with no primary keys. As a result the field I
>want to key
* Chris Fossenier <[EMAIL PROTECTED]> [001029 17:13] wrote:
> Hey,
>
> I am trying to assist a client in structuring their data department.
> My recommendation was moving towards an SQL platform. However,
> now that I have actually done some benchmarking, I'm not so sure
> about that recommendat
Hey,
I am trying to assist a client in structuring their data department. My
recommendation was moving towards an SQL platform. However, now that I have actually
done some benchmarking, I'm not so sure about that recommendation. An SQL platform
like Postgres will give them better management
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
Hello,
I'm sure I'll be flagged as a moron for asking this question, so be it.
I have some tables of info with no primary keys. As a result the field I want to key
on is repeated. My plan is to do a DISTINCT select from the un-keyed table into
another table that does have constraints.
Here
I want to use JDBC with postgresql.
I installed postgresql, and I tried a Java program from postgresql JDBC
examples (called basic.java), but I get the error:
Exception caught :
java.lang.ClassNotFoundException: org.postgresql.Driver ,etc
My CLASSPATH is ok I think.
$ echo $CLASSPATH
/usr/loc
