Sorry to stick my nose in here...would not this work better?SELECT broadcast_id,date_sent,status from broadcast_history whereunique_id in (SELECT max(unique_id) from broadcast_history group by broadcast_id);Seems like a simpler option.
- Original Message -- From:Patrick Jacquot Sent:Friday
Hi all.
I am new to postgres, so I am still
learning the basics.
In Sequel Server, one can set up a function
to return a table eg:
CREATE FUNCTION [dbo].[AuthCodes]
(@CLIENTID INT)
RETURNS @AuthCodes TABLE
(
[ID]
INT,
AUTHCODE
VARCHAR(100),
