Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Basic Trigger Question
I've used triggers before in another DB where the total functionality was included in the CREATE TRIGGER statement, totally written in SQL. I understand that postgresql can't do that (correct?). I want to delete a row in table 2 when I update table 1, with something along the lines of : CREATE...- FatherRon
- Thread
- Replies: 2
- Forum: PostgreSQL Inc.: PostgreSQL
-
need help formulating difficult query
You can use SELECT DISTINCT ON instead of SELECT DISTINCT and specify the field to use it on. SELECT DISTINCT ON (country) id, country FROM mytable WHERE country = 'UK'; The field that you use the DISTINCT ON modifier on must be listed in parentheses before your list of the fields.- FatherRon
- Post #2
- Forum: PostgreSQL Inc.: PostgreSQL
