select
id
into temp images_all
from images
where (invoice_number = '$invoice_number' or quote_number = '$quote_number');


select
distinct on (filename)
id
into temp images_current
from images
where (invoice_number = '$invoice_number' or quote_number = '$quote_number')
AND archive is not true
order by filename ASC,created_date DESC;


select
id
into temp images_archive
from images_all
where id not in (select id from images_current);

SELECT
id,
description,
filename,
to_char (created_date,'YYYY-MM-DD HH24:MI:SS') AS date,
archive

FROM
images
WHERE id in (select id from images_current)
ORDER BY description,created_date