Hello SQL Aces !
I want to do a select on a table distinct on linkid and sorted by
date. I have try this
SELECT DISTINCT ON (linkid) * FROM all_links
WHERE uid='2' AND DATE_TRUNC('day',read_date) = DATE_TRUNC('day',
TIMESTAMP '2005-06-01') ORDER BY linkid, read_date;
With this req
ay',TIMESTAMP '2005-06-01')
ORDER BY linkid
) A
ORDER BY read_date DESC limit 100
------ Original Message ---
From: FC <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org
Sent: Wed, 1 Jun 2005 16:40:48 +0200
Subject: [GENERAL] SQL question.
Hello SQL Aces !
I have all my database encoded in ISO-8859-1 and I would like to
convert this database in UNICODE.
I have try this but with no success.
pg_dump dbase > foo.db
createdb -E UNICODE dbase
psql dbase < foo.db
I have also try to modify the value of client_encoding in the foo.db
file but that d